Right-click the control, select the Control tab, and enter the Input Range.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jithu" wrote in message
...
Can you please tell me how to get the values (source) in the drop down of
a
combo box when the combo box is created on the sheet.(i know how to do
this
when the combo box is in a user form)


Thanks
in advance
jithu