Combo Box Control

Is there a way to populate a Drop Down Combo Box besides the AddItem method.

I have a long list which I would like to make available through a combobox,

but going through the list one at a time with the AddItem method it takes

for ever to populate.

Any ideas wil be grately appreciated...

you could try opening note pad and typing the list

then write a routine that reads in the list.

You should be able to do this in about 4 lines line of code using a for/next loop.


Christopher

I am in need of the same tool I would like to populate my combo box from an excel file. On column A of an excel file I have a list of things I want to display them with a VB combo box. Can anyone help us here?