combobox

  • Thread starter Thread starter Nicky*
  • Start date Start date
N

Nicky*

Hello

Can anyone tell me how to get a list of names in 3
separate ranges on a worksheet, into one long list in a
combobox?

thanks
Nicky
 
Is the combo on a form or directly attached to a worksheet?

Hello

Can anyone tell me how to get a list of names in 3
separate ranges on a worksheet, into one long list in a
combobox?

thanks
Nicky
 
Hi

The combobox is on a form.
There are 3 lists of names on a worksheet which I would
like to put in one long list in the combobox when the form
is activated.
 
Glad you liked it. However, let me clarify one thing. You only loop through
the lists when you are loading up the array. Then, you unload the array into
the combo with additem. The 3 lists would be loaded into the array by using
a "for i = 1 to X" loop containing a nested "do" loop. I would unload them
with a "for i = 1 to X" loop into the box.
Richard

Richard,

How simplistic! Wish I had thought of it! Was going to reply to the first
post until I realized that there were multiple lists to put into the box.

Now it is just a matter of looping through each list and using additem.

I will remember this for future use.

Thanks...

steve
 
Back
Top