software

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: www.excelforum.com/member.php...oamp;userid=32836
View this thread: www.excelforum.com/showthread...hreadid=526325upersad, sounds like data validation will do what you want, have a look here
for information on it

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 amp; 2003

quot;upersadquot; gt; wrote in
message ...
gt;
gt; Hi,
gt; I am trying to prototype an application in Excel. I was wondering if
gt; it is possible to have a drop down box in a cell where a user can
gt; choose a value and then that value becomes the value in the cell.
gt;
gt; For example if I had a list such as {apples, oranges, grapes, ... }, I
gt; want to have a drop down box fit into a cell so a user can choose one
gt; value and that value will become the value in the cell. It is the same
gt; as an HTML drop down box, except I want the box to be contained exactly
gt; in the cell and not floating over it.
gt;
gt; Thanks,
gt; Umesh
gt;
gt;
gt; --
gt; upersad
gt; ------------------------------------------------------------------------
gt; upersad's Profile:
www.excelforum.com/member.php...oamp;userid=32836
gt; View this thread: www.excelforum.com/showthread...hreadid=526325
gt;

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

Regards,
Umesh--
upersad
------------------------------------------------------------------------
upersad's Profile: www.excelforum.com/member.php...oamp;userid=32836
View this thread: www.excelforum.com/showthread...hreadid=526325your 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 amp; 2003

quot;upersadquot; gt; wrote in
message ...
gt;
gt; Thanks a lot for your advice and the link. It answers all my questions.
gt;
gt; Regards,
gt; Umesh
gt;
gt;
gt; --
gt; upersad
gt; ------------------------------------------------------------------------
gt; upersad's Profile:
www.excelforum.com/member.php...oamp;userid=32836
gt; View this thread: www.excelforum.com/showthread...hreadid=526325
gt;