Edit Drop down box
 

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?

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

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

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

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

Hope this will help.

Regards,

Cafe


--
cafe
------------------------------------------------------------------------
cafe's Profile: http://www.excelforum.com/member.php...o&userid=16145
View this thread: http://www.excelforum.com/showthread...hreadid=395201