using worksheet.change function

[connexion]

Hi everyone,
I have some names in column a. now i want to
implement something so that when anyone tries to change column a it
should display a msg box. i need to use the worksheet.change function.
if any other solution is there it wil be welcome.


thanks for all the help

 

[Don Guillett]

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
MsgBox "May I help you? "
End Sub