Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation | Excel Worksheet Functions | |||
data validation | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |