EXCEL FUNCTION

  • Thread starter Thread starter STAN BELBACK
  • Start date Start date
S

STAN BELBACK

I WANT TO CLICK ON A CELL AND AUTOMATICALLY TO A LOCATION
ON THE SAME OR A DIFFERENT WORKSHEET. HOW CAN I DO THIS.
FOR EXAMPLE, I CLICK ON CELL F4 IN SPREADSHEET 1 AND I
AUTOMATICALLY GO TO CELL Z10 IN SPREADSHEET 3.
 
It'd help if you give us all the rules. Is F4 a "trigger" cell?
You can set up a hyperlink in F4 to do that, or you can write code in the
Worksheet_SelectionChange event to do that:
right-click the sheet tab with the "trigger" cell, select "view code", enter
this:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$F$4" Then
Sheets(3).Activate
Sheets(3).Range("Z10").Select
End If
End Sub
 
It is considered rude to shout by typing in all caps. Please don't.
use a worksheet change event.
Right click on the sheet tab>view code>insert this>save.
When you CHANGE f4 you will goto sheet3

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F$4" Then Application.Goto Sheet3.Range("a10")
End Sub
 
Back
Top