Thread: HYPERLINK & Drop BOXs

I have built Excel MSDS system. In the Table of Contents it is simple to set a HYPERLINK to the Product to the correct MSDS sheet on separate “Worksheet”; but to HYPERLINK to Manufacture with mulit-products, I tried to make HYPERLINK "Drop List" so the user select which product he wants to view on separate “Worksheet” witch did NOT work. How can I make a "Drop List" so I can select the correct product from a list of products pre Manufacture?

BEN

I have built Excel MSDS system. In the Table of Contents it is simple to set a HYPERLINK to the Product to the correct MSDS sheet on separate “Worksheet”; but to HYPERLINK to Manufacture with mulit-products, I tried to make HYPERLINK "Drop List" so the user select which product he wants to view on separate “Worksheet” witch did NOT work. How can I make a "Drop List" so I can select the correct product from a list of products pre Manufacture?

It isn't entirely clear from your description but, are you trying to hyperlink within the same workbook? If so, the Hyperlink function cannot be used to navigate within the workbook. You can, of course create internal hyperlinks (not using the function) using Ctrl+K keys, but this is not what you desire since it doesn't work with a drop down.

If you're navigating to another sheet in the workbook, to use the drop down you must use VBA. See attached.

Code:

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim strSheet As String
    
    strSheet = Range("A2").Value
    
    If Not Intersect(Target, Range("A2")) Is Nothing Then
        Application.Goto reference:=Worksheets(strSheet).Range("A1"), scroll:=True
    End If

End Sub

An alternate, non-VBA approach is to name a cell on each sheet and use the Name Box drop down to navigate to the desired sheet. The attached also includes this method.