Bob,
Well, yes, if the OP is looking for an event when any cell value changes.
But I paid more attention to his "SheetSelectionChange" comment.
Depends which he has in mind.
NickHK
"Bob Phillips" wrote in message
...
You mean
Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range).
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"NickHK" wrote in message
...
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