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

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



xavi garriga wrote:

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

--

Dave Peterson