Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
selection from dropdown list activates hyperlink
I want a selection from my dropdown list in a cell to be a hyperlink to
another cell on the same sheet. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
selection from dropdown list activates hyperlink
The effect of a hyperlink can be emulated using the worksheet's _Change()
event handler. Right-click on the sheet's tab and choose [View Code] to get into the proper coding area. You could 'seed' the process with this code, changing the addresses to match your sheet setup and adding more code to handle all of the items in your list. This code is set up as if your list only has 2 items to choose from in it. The words in the Case Is = "" are the actual words in your list. You can add more Case Is = "choice" statements as needed to handle all items in your list. The first test for Target.Address needs to be changed to the address of your list cell, and it must have the $ symbol in front of both the letter and number portion of the address. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$A$1" Then 'was not A1, ignore the change Exit Sub End If Select Case Target.Value Case Is = "First Choice" Range("G4").Select ' go to cell G4 Case is = "Second Choice" Range("B3").Select ' go to cell Be End Select End Sub "jlind50" wrote: I want a selection from my dropdown list in a cell to be a hyperlink to another cell on the same sheet. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy or move a row on a particular dropdown list selection | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
Allow selection of multiple values in dropdown list in excel | Excel Discussion (Misc queries) | |||
Dropdown list key selection | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |