Drop down list - link to another worksheet

[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.

 

[DVAL]

I don't know why, but I could not upload attach

 

[NOPIK]

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!

for each WSHT in MyDOC.Worksheets
DropDown1.additem WSHT.Name
next WSHT

 

[CellShocked]

for each WSHT in MyDOC.Worksheets
DropDown1.additem WSHT.Name
next WSHT

But they are not links.

 

[DVAL]

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!

for each WSHT in MyDOC.Worksheets
DropDown1.additem WSHT.Name
next WSHT