Hi Nick,
He did say
.... when a cell changes value but w/o a Worksheet_Change for each worksheet.
Sort of a global callback....
but he did get confused didn't he? <G
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"NickHK" wrote in message
...
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