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?