Home |
Search |
Today's Posts |
#1
|
|||
|
|||
create dropdown menu
Hi,
can anybody advise (or direct me to basic creation site) where I can create a dropdown menu in excel. the menu will hold seveal options ie Food, Drink, Price etc and I want the user to be able to select one of the options and once chosen a specific excel worksheet will be opened for this topic. thanks Anthony |
#2
|
|||
|
|||
Hi Anthony
by drop down menu do you mean one like File / Edit / View on the menu bar or in a cell in a workbook. If you want the file / edit / view type probably the easiest way to it is to record a different macro opening each of the specific workbooks and then use view / toolbars / customise to drag a new menu item onto the toolbar, and then drag one for each item and assign the appropriate macro to it. if you want a drop down list in a cell - you could use data validation to create the drop down (check out http://www.contextures.com/xlDataVal01.html ) and then use a worksheet_change event to open the appropriate book, e.g. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$E$4" And Target.Value < "" Then Select Case Target.Value Case "food" Workbooks.Open Filename:="C:\My Documents\food.xls" Case "drink" Workbooks.Open Filename:="C:\My Documents\drink.xls" Case "price" Workbooks.Open Filename:="C:\My Documents\price.xls" End Select End If End Sub --- Hope this helps, please post back if you require further information. Cheers JulieD "Anthony" wrote in message ... Hi, can anybody advise (or direct me to basic creation site) where I can create a dropdown menu in excel. the menu will hold seveal options ie Food, Drink, Price etc and I want the user to be able to select one of the options and once chosen a specific excel worksheet will be opened for this topic. thanks Anthony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown menu | Excel Worksheet Functions | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
how do I create a drop down menu in Excell? | Excel Worksheet Functions | |||
how do i create drop down menu in excel | Excel Worksheet Functions |