Did you get the control from the forms toolbar, that has the Format Control
option?

--
---
HTH

Bob


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



"Sai Krishna" wrote in message
...
I am using excel 2000. I am trying to create a drop down list but not able
to
give the range of input as there is no option in Forma Control. How can I
give the range?
regards
sai