Drop down box in a cell

  • Thread starter Thread starter upersad
  • Start date Start date
U

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
 
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
 
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
 
Back
Top