Worksheet_Change

[MLT]

I have the following generic code to spot when a cell is changed in a
single worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)
Msgbox Target.Address
End Sub

Is there such thing as a sort of "Workbook_Change" so that any cell in
any sheet of the workbook will still trigger the msgbox?

 

[Dave Peterson]

There's a Workbook_SheetChange that belongs under the ThisWorkbook module.

You may want to use:
Msgbox Target.Address(external:=true)
or
Msgbox Target.Address & vblf & sh.name

 

[OssieMac]

Yes. In the VBA editor on the left side is the project explorer. Double click
ThisWorkbook and insert the following code. Note it returns both sheet an an
object and the range.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

MsgBox Sh.Name & " " & Target.Address

End Sub

Note that at the top of the VBA editor where you place the code there are 2
drop down boxes. For whatever module you are in, you click the left one then
you can select the object for which you want code and then clicking the
dropdown on the right will display all of the events. Clicking one of the
events creates the Private Sub .... End Sub for the particular event.

 

[MLT]

Beautiful. Thank you.