Populating items in a ComboBox

[Grizlore]

Hi All,

I am trying to automatically pick up a selectable list of supplier names into a userform ComboBox and i am a little stuck

I have several hundred supplier names in a worksheet called "Supplier List" and I would like to be able to select one of these in the Userform.

As there is so many, the "ComboBox1.AddItem " method isn't feasible.

Could someone offer a suggestion please?

Help appreciated please

 

[Fluff]

Are the names in the list, or can there be duplicates?

 

[Grizlore]

Thanks for your reply

They should all be unique names, and no duplicates

 

[Fluff]

In that case you can do it like

Me.ComboBox1.List = Range("A2:A100").Value

 

[Grizlore]

That work perfectly - thanks for your time!

 

[Fluff]

You're welcome & thanks for the feedback