Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
edit a drop down list | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |