View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Excel drop down menu

Is this a dropdown menu in one of your menu bars, or is it a dropdown
list in a cell?

If it's a data validation dropdown list in a cell, choose
DataValidation, and see what the list source is. If the list is typed
in the dialog box, add another item to the typed list.

If the list is in a worksheet range, add your item to the worksheet
list, and change the cell reference in the data validation dialog box.

There are instructions in Excel's help, and he

http://www.contextures.com/xlDataVal01.html

Christine.Brophy wrote:
How can I add another option to a drop down menu that has already been
created in an excel wroksheet



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html