drop down list with hyperlinks

Hi,

I'm trying to create a drop down list where each line of the drop down list has a hyperlink to a different document. I am using Excel 2019, with Microsoft Windows 7. I already know how to create the drop down list, it the hyperlink to each line (about 50) on the drop down list that I can't figure out.

Thanks

Hi,

Can you post a sample of the workbook? You can remove sensitive data. What does the hyperlink do? Open a document or go to a specific place on the current document. Is there a relationship between the value and the hyperlink.

Thanks

I'm just using the basic drop down list creation using data validation. I'm trying to create hyperlinks to documents on a SharePoint site, or a common drive. Attached is a non-sensitive sample of how I'm creating the drop down list.

Thanks!

Hi,

See if this helps:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim sPath As String
Dim sExt As String

' Set the default path and the extensions of the file
sPath = "C:\MyFolder\"
sExt = ".xlsx"

If Target.Column <> 1 Then Exit Sub

Application.EnableEvents = False
    ' Add the hyperlink
    Target.Hyperlinks.Add Anchor:=Target, _
                          Address:=sPath & Target.Value & sExt, _
                          TextToDisplay:=Target.Value
Application.EnableEvents = True

End Sub

You will have to place this code under the sheet where the list is module.
To go there press F11 and the to the left double click the sheet name. Paste the code in the white area.

sample.xlsm

Thanks