Cell selection macro

[not very bright dave]

Hi

I want to be able to say

'if cell a5 is selected, then .....'

How do I do this?

Thanks

Dave

 

[R_Stephens]

Hi there,

Try this,

If Selection.Address = "$A$5" Then
    <Put your code here for when A5 is selected
Else
    <Put your code here for when A5 is not selected (this can be left blank)
End If

Change the $A$5 to be what ever cell you need to check

Hope this helps

Richard

 

[not very bright dave]

Hi Fergus

Where do I put this code?

Thanks

Dave