combobox Promblem

[Molden]

Hi,
Could any one tell me what is the best way to add a list to a combobox, my list is on sheet4 and in range (A54:A67) and my combobox is on sheet3. Ive tried:

for n = 54 to 67
sheet3.combobox4.additem sheet4.cells(n,1)
next

which works if it is on a userform but if its on a sheet then it keeps on doubling up with the same options
Can someone help please
Thanks

 

[Lewiy]

If you are using that method then you would need:

Sheets("Sheet3").ComboBox4.Clear

Before you add the items.

However, I would personally use:

Sheets("Sheet3").ComboBox4.ListFillRange = "Sheet3!A54:A67"

 

[Molden]

Thanks