Macro doubt

[Guest]

Hi to everyone;

I need to fill a comboBox with a row instead of a column. How colud I do it?
The restriccion is that I can't transpose the row.

Thanks to all.

 

[Dave Peterson]

Use code to fill the combobox.

Look at the .additem method for the combobox.

dim myRng as range
dim myCell as range
set myrng = worksheets("sheet1").range("a1:e1")
for each mycell in myrng.cell
me.combobox1.additem mycell.value
next mycell