Aaron,
There is the Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range).
So you get the sheet and range.

If you to further, there's also Application_SheetSelectionChange(ByVal Sh As
Object, ByVal Target As Range).
http://www.cpearson.com/excel/AppEvent.htm

NickHK

wrote in message
oups.com...
Hi,

Is there a way to have a callback that fires when a cell changes value
but w/o a Worksheet_Change for each worksheet. Sort of a global
callback.

I haven't done VBA programming in a couple years (can fight the
withdrawl no longer) and I seem to recall that there's a way to create
an object or something like that for this purpose. For example, in my
old code I'm seeing this "app_SheetSelectionChange" code. No longer
sure how it works, but something like that...

Thanks!

Aaron Fude