Home |
Search |
Today's Posts |
#1
|
|||
|
|||
create menus in excel worksheet
hi,
As a novice to Excel programming the answer to this question could be easy, or difficult. I have a worksheet which I want to add two drop down menus - just like in the normal excel application that will on selection give me a drop down menu of subjects. When a certain subject has been chosen a specific task will be carried out. For example two drop down menus in exel that I want to create in a 'cell' on my worksheet are "View" and "Tools". When the user selects "view" the menu appears with subjects such as "graph", "stats", "Telephone" and once one of these subjects is chosen the relevant worksheet for that subject is opened. Hope I have made myself clear, and thanks for your help Regards Anthony |
#2
|
|||
|
|||
Hi Anthony
Debra Dalgleish has notes on dependant drop down lists on her site (http://www.contextures.com/xlDataVal02.html)... what you'll need to do then is code a worksheet_change event so when an option in the second list is chosen that worksheet is displayed. e.g. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$1" And Not IsNull(Target.Value) Then Sheets(Target.Value).Activate End If End Sub - if the names of the items in the second drop down are the same as the sheet names .. . Hope this helps Cheers JulieD "Anthony" wrote in message ... hi, As a novice to Excel programming the answer to this question could be easy, or difficult. I have a worksheet which I want to add two drop down menus - just like in the normal excel application that will on selection give me a drop down menu of subjects. When a certain subject has been chosen a specific task will be carried out. For example two drop down menus in exel that I want to create in a 'cell' on my worksheet are "View" and "Tools". When the user selects "view" the menu appears with subjects such as "graph", "stats", "Telephone" and once one of these subjects is chosen the relevant worksheet for that subject is opened. Hope I have made myself clear, and thanks for your help Regards Anthony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create qif files from Excel for import into Quicken? | Excel Discussion (Misc queries) | |||
Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions | |||
Create invoices from excel workbook | Excel Worksheet Functions | |||
how do I show dates in a column in an excel worksheet? | Excel Discussion (Misc queries) | |||
Is there a way to create a standard OHLC bar chart in Excel? | Charts and Charting in Excel |