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.
-----Original Message-----
Is the combo on a form or directly attached to a
worksheet?

"Nicky*" wrote in message
...
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


.