Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Navigating worksheet tabs | Excel Discussion (Misc queries) | |||
Navigating on a worksheet | Excel Discussion (Misc queries) | |||
Combo box in a worksheet | Excel Discussion (Misc queries) | |||
CTRL Find is preventing me from navigating around my worksheet | Excel Discussion (Misc queries) | |||
Navigating within worksheet | Excel Discussion (Misc queries) |