PDA

View Full Version : Worksheet_Selection not working



paddysheeran
03-02-2012, 08:34 AM
Hi there,

for some reason my code is not working. Can anyone help:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Address = "$F$5" Then
Range("A3") = "Message here"
Else
Range("A3") = ""

End Sub

any help would be greatly appreciated

thanks,

paddy.

JKwan
03-02-2012, 09:00 AM
What do you mean by not working?
Is it the procedure not run when you select different cells? If so, perhaps your events are turned off.

mdmackillop
03-02-2012, 10:05 AM
Missing End If