| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down list - link to another worksheet
Hi How to make Drop down list (Form Control - Combo box) with names of worksheets and then when I select a list value that I created I want to go to another worksheet. SO, I want to pick one name from Drop down list and that worksheet then opens! What code do I need to enter? I have tried: Sub DropDown1_Change() If DropDown1.Value = "1" Then Sheets("Ivan").Select ElseIf DropDown1.Value = "2" Then Sheets("Marko").Select ElseIf DropDown1.Value = "3" Then Sheets("Pero").Select End If End Sub Examle is in atttach! Does anybody know? Thank you for reading this especially if you are able to help me out on this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Link drop-down list? | Excel Programming | |||
| How do I link 2 drop down list together? | Excel Discussion (Misc queries) | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| Link Second drop-down list to a Worksheet | Excel Programming | |||
| Link Second drop-down list to a Worksheet | Excel Programming | |||
Threaded Mode
