using a mac: populating combobox with values in a column..... (no 'row source'!)

[tb13]

Hi there,

I have recently converted to a mac, and am getting used to some of the subtle differences in excel. One of them being, how to enter a list of names into a combobox. Basically, I have 100 names in column A (e.g., A1 to A100) and I want these names to appear in a combobox when I open a userform.

On the windows computer, it was simply a matter of changing the 'row source' in the properties menu. I am sure there is a simple solution on the mac too but I cant seem to figure it out.

Any help would be great. Cheers.

[jraj1106]

Hi.

Try this code. I have a form with combobox:

fillcombobox.xlsm

[tb13]

thanks jraj1106! works well