and yes I'm using a user form

"Bob Phillips" wrote in message
...
Link the RowSource (if a form) property of the combobox to the range of
data
on the worksheet, and set the Controlsource property to D4 to get the
value
stored there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"James Montgomery" wrote in message
...
Hi,

Can someone help me with populating a ComboBox with say
Text Line 1
Text Line 2
Text Line 3
Than after the user chooses one say 'Text Line 2' have it show his pick
in
the Combobox. User would than have to click an 'OK' button to dislplay
it
in
say in ("D4"). I would want the ability to able to add more 'Text Lines'
to
the code myself.

If this is asking to much could someone direct me to a site that might
have
such a routine or to someone I could pay for his or her services.
Thanks,
James