Trigger worksheet_change

Hello Helmekki,

The event that is triggered by the code is

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

End Sub


You can add the following code to this event to monitor cell A2

If Target.Address = "A2" Then
<execute your code>
End If
_________________________________________________________________

Hope this helps,
Leith Ross

Hello Helmekki,

If I understand correctly, the code is simply updating the cell on worksheet 2 when cell value of worksheet 1 changes.

Add this code to the worksheet 1's Private Sub Worksheet_SelectionChange Event
_________________________________________________________________


Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

If Target.Address = "$A$1" Then
Worksheets("Sheet2").Range("A1").Value = Target.Value
End If

End Sub

_________________________________________________________________

This automatically updates cell A1 on sheet 2 when cell A1 on sheet 1 is selected by the user but not by code. Worksheet events are driven externally. There are no internal events that are exposed to the VBA environment. You may need to re-evaluate your program design. In code you can do want you want, when you want. You are freed from waiting for the user, unless you need to wait for some specific action or input from the user.


Hope this helps,
Leith Ross