The combobox has a RowSource property. Set this to the range,, such as
A1:A10.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rookie" wrote in message
...
I am creating a userform with comboboxes but I do not know how to link the
combobox to the data that I want in it. I know this has to be very simple
and basic, but I just can't figure it out.