Greg B expressed precisely :
Hi All,

I need to fill a combobox with data I have on a sheet called stock. The part
numbers are in Column A. What I would like is populate with the correct
amount. I assume if I used the whole column the combobox fill would be huge.

Explain what you mean by "the combobox fill would be huge". Are there
duplicate part numbers or just lots of them? (I assume you don't want
blanks!)

Do you want to load the combobox with a specific number of items at a
time and provide controls for stepping through all items by moving in
next-in-line?

Do you want a sorted list?

Would a listbox possibly serve you better since users could simply
click an item as apposed to opening the list and navigating it to
select an item? (Note that a combobox will cycle through all entries
that begin with the first letter typed, and so may be the better tool
for the job at hand)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion