[RESOLVED] Excel internal link

[MartinLiss]

In an xlxs workbook on Sheet1 there is a textbox that when clicked takes me to Sheet2!A1, How is a link like that created?

[OptionBase1]

Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    Application.Goto Reference:=Worksheets("Sheet2").Range("A1"), Scroll:=True
End Sub

[Zvoni]

In an xlxs workbook on Sheet1 there is a textbox that when clicked takes me to Sheet2!A1, How is a link like that created?

Are you sure it's a TEXTBOX?

Screenshot?

[MartinLiss]

@OB1: It's an xlsx workbook so I don't believe your suggestion can work.
@Zvoni: Thanks. It definitely is a textbox. However when right-clicking on it I noticed 'Edit Link' which solves my problem.

[Dan_W]

Are you sure it's a TEXTBOX?

Screenshot?

That was my first thought, but I suspect he means the Textbox Shape and not the one you add by way of the Developer tab.