SelectionChange Event
The Target.Address has the "$" in it. Change your code to:
If target.Address = "$A$18" Then...
"James" wrote in message
...
I am trying to use the worksheet_selectionchange event and it doesn't seem
to
be doing anything. I would like to call a sub routine when the user clicks
on
cell "a18"
I am trying just to see if I can get the event to trigger and no matter
what
I do nothing happens
right now I tried this:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "A18" Then
MsgBox "hello"
End If
End Sub
This is in the worksheet that I want it to run for
Do I have to turn on anything for this event to work?
Am I missing something?
Thanks
|