Edit Drop down box

K

kamill

I need to add additional choices to an existing drop down box. I can't find
the current source to add additional choices. Can someone help me?
 
P

Paul B

kamill, is the list a data validation list? If so see if this will help, if
not post back with more details

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
 
C

cafe

If it is a Validation box:
In the cell that has the box: Goto excel menu Data/Validation see i
there you can see the range for the list.

If it is a Forms "List Box" the right click the list box, selec
"Format Control" select the "Control" tab to see the range..

Hope this will help.

Regards,

Caf
 
Top