Drop down list hyperlink

[DVAL]

How to make Drop down list (Form Control - Combo box)
with names of worksheets and HYPERLINK to that worksheets in the same
workbook.

SO, I want to pick one name from Drop down list and that worksheet then
opens!

Sorry for bad English

Does anybody know?
Thank you for reading this especially if you are able to help me out on
this.

 

[Gord Dibben]

How about a sheet navigation toolbar from Dave Peterson?

http://www.contextures.on.ca/xlToolbar01.html

Or Bob Phillips' Browsesheets macro which I like best, but that's me<g>

See this google search result for code.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP

 

[DVAL]

Thanx on that, but I need something simplest.
I tried with
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
in VBA but I'm new in VBA.
I got Error '424'
Object required

 

[CellShocked]

Can you not simply make a list of hyperlinks, and then mark and name
that listed range, and then refer to the named range when you do the drop
down list box dialog?

 

[DVAL]

I tried, but is not working.

Now I know to do this something similar with Data Validation
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$H$4" Then
Select Case Target.Value
Case "Ivan"
Sheets("Ivan").Activate
Case "Marko"
Sheets("Marko").Activate
Case "Pero"
Sheets("Pero").Activate
End Select
End If
End Sub

and with Active X combo box
Private Sub ComboBox1_Change()
Sheet2.Activate
Select Case ComboBox1.Value
Case "Ivan": Sheet2.Range("B4").Select
Case "Marko": Sheet2.Range("B6").Select
Case "Pero": Sheet2.Range("B8").Select
End Select
End Sub


but I don't know how to edit this Active VBA because this link is only for
Sheet no2