using worksheet.change function

  • Thread starter Thread starter connexion
  • Start date Start date
C

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
 
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
MsgBox "May I help you? "
End Sub
 
Back
Top