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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box 2
Having trouble with combo boxes. 11
refreshing combo box in form? 1
Input/combo box 2
combo box linked to named range 4
Userform Combo box to mimick Worksheet Cell validation list range. 2
Using a Combo Box text selection to find text on another worksheet 1
Combo Box Unique Entries 1

Back
Top