Macro doubt

X

xavi garriga

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.
 
D

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
 
Top