Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks in a drop down menu
Does anyone know how to create a drop down menu that contains hyperlinks to different parts of the same worksheet? Thanks for any help!!! -Brian -- B_Ward ------------------------------------------------------------------------ B_Ward's Profile: http://www.excelforum.com/member.php...o&userid=29829 View this thread: http://www.excelforum.com/showthread...hreadid=495502 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks in a drop down menu
There may be a way but I can't think of one offhand. You could just create
regular hyperlinks in each cell and have the user click the appropriate cell. Or...you could create a regular drop down menu and have a macro run that would activate the appropriate cell based on the value the user chose from the drop down menu. You would need to do coding for that though. Probably in the SheetChange event with the cell where you put the drop down list as the target. Hope this helps. Bill Horton "B_Ward" wrote: Does anyone know how to create a drop down menu that contains hyperlinks to different parts of the same worksheet? Thanks for any help!!! -Brian -- B_Ward ------------------------------------------------------------------------ B_Ward's Profile: http://www.excelforum.com/member.php...o&userid=29829 View this thread: http://www.excelforum.com/showthread...hreadid=495502 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks in a drop down menu
Try this below code... It assumes that I named the cell that has the
dropdown list as "DropDown" and that I named the 5 cells that a user could hyperlink to as "Spot1", "Spot2", etc... You don't have to name the cells, I just did it for ease of code writing. I also named the worksheet as WS which refers to the worksheet HyperlinkTest. You would need to put this code in the Worksheet Change section of the appropriate worksheet through the VBA editor. You will also have to create a dropdownl list with the appropriate values. Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False Dim WS As Worksheet Set WS = ThisWorkbook.Worksheets("HyperlinkTest") If Target.Address = WS.Range("DropDown").Address Then Select Case WS.Range("DropDown").Value Case "Spot1" WS.Range("Spot1").Activate Case "Spot2" WS.Range("Spot2").Activate Case "Spot3" WS.Range("Spot3").Activate Case "Spot4" WS.Range("Spot4").Activate Case "Spot5" WS.Range("Spot5").Activate End Select End If Application.ScreenUpdating = True End Sub Hope this helps. Thanks, Bill Horton "William Horton" wrote: There may be a way but I can't think of one offhand. You could just create regular hyperlinks in each cell and have the user click the appropriate cell. Or...you could create a regular drop down menu and have a macro run that would activate the appropriate cell based on the value the user chose from the drop down menu. You would need to do coding for that though. Probably in the SheetChange event with the cell where you put the drop down list as the target. Hope this helps. Bill Horton "B_Ward" wrote: Does anyone know how to create a drop down menu that contains hyperlinks to different parts of the same worksheet? Thanks for any help!!! -Brian -- B_Ward ------------------------------------------------------------------------ B_Ward's Profile: http://www.excelforum.com/member.php...o&userid=29829 View this thread: http://www.excelforum.com/showthread...hreadid=495502 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlinks in drop down menu | Excel Worksheet Functions | |||
hyperlinks in drop down menu | Excel Worksheet Functions | |||
Help with drop down menu | Excel Worksheet Functions | |||
How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
Drop down menu | Excel Discussion (Misc queries) |