I don't know why, but I could not upload attach :(
"DVAL" wrote in message ...

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.