Combo Box for navigating in a worksheet
 

I want to use a combo box in a worksheet i have created
that lists 50 different pages within the same worksheet.
i have defined the input range and all 50 pages are
listed in the combo box. However, to goto the selected
page in the combo box, what do i have to do?

Combo Box for navigating in a worksheet
 

Mase,

You can just get the value in put

Private Sub ComboBox1_Change()
Worksheets(ComboBox1.Value).Activate
End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mase" wrote in message
...
I want to use a combo box in a worksheet i have created
that lists 50 different pages within the same worksheet.
i have defined the input range and all 50 pages are
listed in the combo box. However, to goto the selected
page in the combo box, what do i have to do?