VBA to follow Hyperlink

[JLouis]

Hello! I've been able to create a dropdown with an active X control that populates a list of hyperlinks, but when I choose the hyperlink from the dropdown it just shows the name of the sheet and doesn't actually hyperlink to the sheet.

How can I make the selection hyperlink to the selection?

Thanks.

 

[Jeffrey Mahoney]

Please look at this method. I created a data validation to look at the sheet names list. Then when the cell changes a macro runs to activate that sheet. The Data Validation cell was given a named range of DV.

Book6
	G	H	I
2	Data Validiation
3	Sheet3		Sheet2
4			Sheet3
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
G3:H3	List	=$I$3:$I$4

Private Sub Worksheet_Change(ByVal Target As Range)
  If Not Intersect(Target, Range("DV")) Is Nothing Then
    Sheets(Range("DV").Value).Activate
  End If
  
End Sub

 

[JLouis]

Very nice. I was able to incorporate this method successfully. Thank you for the directions.