Combobox_userform_range question

[sweetboy02125]

I have a userform with a combobox inside.
I would like to populate a range in a worksheet as a drop down list.

Please Login or Register  to view this content.

Can you help to see what wrong with the code? I had a message "Type missmatch"
I can use Rowsourse in the properties window to populate a range but they include the blank cells.

Thanks

[royUK]

N cannot be Nothing, it might be 0, but your code runs from n=2 to20. The mismatch error is because it is declared as a Long

A little more explanation & an example workbook would help

[sweetboy02125]

Basiclly i have a list of data in column 5 or E ( can be 5 or 6 or 9... name). Just would like to populate them in a userform combobox. The code i had is trying to add all of names in the "Option" worksheet to the combobox. it adds until the last row is blank then stop.

[sweetboy02125]

Please Login or Register  to view this content.

i got it thanks.