array to fill combo box

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

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?

Please Login or Register  to view this content.

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

@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?

Change A1 to E1.

it could be also dynamic deffined Range

Please Login or Register  to view this content.

BR
MaczaQ