msgbox when worksheet is edited

[Erich Duff]

All,

I've been trying to get a message box to appear whenever a workbook is edited, but for some reason I can't get it to work. Should be pretty simple, no?

----------------
Private Sub Worksheet_Change()
MsgBox "If editing this book, please sort on the Customer field when finished. Also, please be sure to retain formats when editing or adding to the workbook."
End Sub
------------------

But I get a "Procedure declaration does not match description of event or procedure having the same name".

Any thoughts?

Erich

 

[Norie]

Erich

The error message says it all really.

The worksheet change event has the Target argument.

Private Sub Worksheet_Change(ByVal Target As Range) 
MsgBox "If editing this book, please sort on the Customer field when finished. Also, please be sure to retain formats when editing or adding to the workbook."

End Sub

 

[Erich Duff]

Of course. I knew it looked a little funny. Still learning!

Thanks, Norie.

Erich