View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default using worksheet.change function

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"connexion" wrote in message
...
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