Callback for a cell changing with less code
 

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

Callback for a cell changing with less code
 

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

Callback for a cell changing with less code
 

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

Callback for a cell changing with less code
 

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

Callback for a cell changing with less code
 

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