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?

I tackled this project about six months ago. I can email you the file
if you would like. I made it into a xlAddin and used a class module to
tap into application events so I can use it for any workbook. Post your
email here if you would like me to send you the finished work.

HTH

Die_Another_Day

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?

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?

Hi Charlie,
The wb holds plus 60 ws hence I need to find an easier meethod that will
work for some 600 users. I have a hyperlinked index but it is getting
unwieldly.

Thanks,
Mickey



"Charlie" wrote in message
...
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?

Hi,
That sounds worth lookingh at, I'll email you off line so as to avoid too
much spam from email harvesters.

Thanks,
Mickey


"Die_Another_Day" wrote in message
ps.com...
I tackled this project about six months ago. I can email you the file
if you would like. I made it into a xlAddin and used a class module to
tap into application events so I can use it for any workbook. Post your
email here if you would like me to send you the finished work.

HTH

Die_Another_Day

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?

How about this from Debra Dalgleish's site:
http://contextures.com/xlToolbar01.html

You could modify it to do what you want with the multiple comboboxes--or just
leave it as is and have it work with any 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?

--

Dave Peterson

the one thing I did diferent from the Debra's website was to use the
ClassModule to intercept the application level event of worksheets
change to update my combo box.
Let me know if you want the workbook.

Die_Another_Day


Dave Peterson wrote:
How about this from Debra Dalgleish's site:
http://contextures.com/xlToolbar01.html

You could modify it to do what you want with the multiple comboboxes--or just
leave it as is and have it work with any 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?

--

Dave Peterson