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.
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.