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
Are you sure it's a TEXTBOX?Quote:
Originally Posted by MartinLiss
Screenshot?
@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.
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.Quote:
Originally Posted by Zvoni