Drop down list - link to another worksheet

  • Thread starter Thread starter DVAL
  • Start date Start date
D

DVAL

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.
 
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!
Click to expand...
for each WSHT in MyDOC.Worksheets
DropDown1.additem WSHT.Name
next WSHT
 
Hi
I don't understand what did you mean with that?
;(

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!
Click to expand...
for each WSHT in MyDOC.Worksheets
DropDown1.additem WSHT.Name
next WSHT
 
Back
Top