Drop down box in a cell

[upersad]

Hi,
I am trying to prototype an application in Excel. I was wondering if
it is possible to have a drop down box in a cell where a user can
choose a value and then that value becomes the value in the cell.

For example if I had a list such as {apples, oranges, grapes, ... }, I
want to have a drop down box fit into a cell so a user can choose one
value and that value will become the value in the cell. It is the same
as an HTML drop down box, except I want the box to be contained exactly
in the cell and not floating over it.

Thanks,
Umesh

 

[Paul B]

upersad, sounds like data validation will do what you want, have a look here
for information on it

http://www.contextures.com/xlDataVal01.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[upersad]

Thanks a lot for your advice and the link. It answers all my questions.

Regards,
Umesh

 

[Paul B]

your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003