array to fill combo box

[kieranbop]

I'm currently having difficulties trying to fill a combo box from data on a spreadsheet. As in just one row.

Please Login or Register  to view this content.

then I'm stuck. Just don't know what to do from their to read up to the last row in a column for the combo box.

Any help appreciated

[kieranbop]

Please Login or Register  to view this content.

editted code as it was to try and read data into a dropdown but no luck.. no errors prompted, or does anyone know an easier way to read excel information to a combo box?

[Bob Phillips]

Please Login or Register  to view this content.

[MaczaQ]

notice that combobox listindex starts with index 0 whilst indexes of cells always starts from 1 - maybe it is a reason

[tip] for fill out ComboBox you can use for example:

Please Login or Register  to view this content.

Best Regards
MaczaQ

[kieranbop]

@mac the range of the combo box can vary at any given time

@bob the code you sent me alone enough to have the combo box drop down for column 5? or what else would be needed for it to read that?

[Bob Phillips]

Change A1 to E1.

[snb]

Probably this suffices:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[MaczaQ]

it could be also dynamic deffined Range

Please Login or Register  to view this content.

BR
MaczaQ