cell message prompt

[bronwyn]

hi again all, what i want to do seems fairly simple, but i cannot work out how to display a message when a particular cell is clicked/selected on a worksheet, any help as always most appreciated

 

[VoG]

Right click the sheet tab, select View Code, paste in the following

Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address(0, 0) = "A1" Then MsgBox "You clicked A1"
End Sub

Substitute A1 with the address of the cell you want the notification for.

 

[bronwyn]

thanks this works perfectly! x