M
Mickey
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?
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?