Hi. I am trying to use the double click on a command button in sheet 1 to go to a specific cell in sheet 3.
I opened a new module and this the code I have (which doesn't work):
Private Sub CommandButton1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Application.Goto Worksheets("Sheet3").Range("H60"), Scroll:=True
End Sub
Can anyone tell me what is the problem here?
Thanks,
Emily
I opened a new module and this the code I have (which doesn't work):
Private Sub CommandButton1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Application.Goto Worksheets("Sheet3").Range("H60"), Scroll:=True
End Sub
Can anyone tell me what is the problem here?
Thanks,
Emily