Excel Hyperlinks and VBA

Question

I have a Data Validation list

which refer to my various worksheets

I would like to be able to select the worksheet I wish to view / jump to and use a VBA button to take me to that worksheet.

Is this possible please?

PS: I would like a single button to go to the sheet selected from the dropdown

user6432984 · Accepted Answer · 2016-06-19 13:10:26Z

1

In the VBA Project window double click the Worksheet that has your validation list. This will open the that Worksheet's code module. Paste this code and change Range("E1") to the correct cell address.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    If Not Intersect(Taget, Range("E1")) Is Nothing Then
        On Error Resume Next
            Sheets(Range("E1").Text).Select
        On Error GoTo 0
    End If

End Sub

answered Jun 19, 2016 at 13:10

user6432984

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel Hyperlinks and VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related