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?
Printable View
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?
Code: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
@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.