Combo Box for navigating in a worksheet

  • Thread starter Thread starter Mase
  • Start date Start date
M

Mase

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?
 
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)
 
Back
Top