Macro doubt

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top