Navigate Sheets using In-Sheet Combo Boxes

[imitk]

I've got a menu ComboBox and I want selecting an item to activate a
corresponding sheet in the workbook. Thinking of writting a macro that
calls several subsequent macros (already written) that activate the
sheets, but I'm a little fuzzy on coding for In-sheet controls.

Suggestions?

imitk

 

[Gary''s Student]

I do something similar with a simple Data Validation pull-down list. The
list contains all the worksheet names. When I select one of them, this
little event macro takes me right there:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim w As Worksheet
If Intersect(Target, Range("A1")) Is Nothing Then
Else
n = Range("A1").Value
For Each w In Worksheets
If w.Name = n Then
w.Activate
End If
Next
End If
End Sub