How 'bout right-clicking on the tab-scroll-arrows down there in the
lower-left corner of the workbook?

"Mickey" wrote:

Hi,
Please could someone advise how best to complete the following -

I have a workbook with quite a lot of worksheets. To simplify navigation I
would like to use three comboxes in the following way -

Combobox 1 populated with a top level list of items.
Combobox 2 populated with a sub list based on the top level item selected in
combobox 1
Combobox 3 then populated with a sub list of items following selection in
box 2. The items in combobox 3 to act as a hyperlink to the selected
worksheet.

For example,
Combobox 1 holds the values Apples & Pairs, User selects Apples and Combobox
2 then populates with Baking, Cooking or Salad. User selects Cooking and
selection hyperlinks to the worksheet named 'Cooking'.

Thanks,
Mickey
ps. An alternative may be to just have a long list in one listbox, can I
have it so that the chosen item then hyperlinks to the selected worksheet?