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


--
upersad
------------------------------------------------------------------------
upersad's Profile: http://www.excelforum.com/member.php...o&userid=32836
View this thread: http://www.excelforum.com/showthread...hreadid=526325

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" wrote in
message ...

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


--
upersad
------------------------------------------------------------------------
upersad's Profile:
http://www.excelforum.com/member.php...o&userid=32836
View this thread: http://www.excelforum.com/showthread...hreadid=526325

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

Regards,
Umesh


--
upersad
------------------------------------------------------------------------
upersad's Profile: http://www.excelforum.com/member.php...o&userid=32836
View this thread: http://www.excelforum.com/showthread...hreadid=526325

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

"upersad" wrote in
message ...

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

Regards,
Umesh


--
upersad
------------------------------------------------------------------------
upersad's Profile:
http://www.excelforum.com/member.php...o&userid=32836
View this thread: http://www.excelforum.com/showthread...hreadid=526325