Using Hyperlinks in Data Validation
 

I want to make a drop down list using data validation. The problem I am
having is the list needs to be hyperlinks to connect to sheets within the
same workbook.

Using Hyperlinks in Data Validation
 

Scott

What you are trying to do cannot be done without some VBA code.

You could use event code which would use the value selected to go to the other
sheet.

Instead of using the list of hyperlinks enter a DV list of just a description of
where you want to go.

Then the selected item would trigger the code.

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub
On Error GoTo endit
Application.EnableEvents = False
Select Case Target.Value
Case "sht1"
Sheets("Sheet1").Select
Case "sht2"
Sheets("Sheet2").Select
End Select
endit:
Application.EnableEvents = True
End Sub

This is event code. Right-click on the sheet tab and "View Code"

Copy/paste the above into that sheet module.

There are other methods of setting up a sheet selector.

Post back if you want to see something else.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 08:30:02 -0800, Scott@CW
wrote:

I want to make a drop down list using data validation. The problem I am
having is the list needs to be hyperlinks to connect to sheets within the
same workbook.