The cell reference for the combo box is a number.
To this number (Cell X) use this formula:
=VLOOKUP(Cell X,Table,2)
Where Table is 2 columns by several rows, depending on how many value
you have in your drop down list. The first column lists 1, 2, 3... th
second gives the Path Name to where the hyperlink would take you.
This formula =VLOOKUP(Cell X,Table,2) works out what sheet to jump to
We'll call this Cell Y.
Design a simple macro that copies Cell Y and pastes the Values Onl
somewhere say Cell Z and follow the hyperlink to Cell Z
Alternatively, if you only have a few sheets, it's alot simpler.
Use the =VLOOKUP(Cell X,Table,2) equation, though this time column 2 i
a list of numbers also, these numbers give the sheet reference, i.e.
leads to sheet3.
Within the macro, copy the Cell Y and paste Values Only to Cell Z,
If Cell Z = 1 Then
Sheets("Sheet1").Select
End If
If Cell Z = 2 Then
Sheets("Sheet2").Select
End If
etc..
If the macro can't be assigned to the combo box, (so the macro runs o
change) then you'll have to run it manually after changing the comb
box. I prefer inserting word art "Run Macro" for example, because wit
this you can assign macros
