Callback for a cell changing with less code

[aaronfude]

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

 

[NickHK]

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

 

[Bob Phillips]

You mean

Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range).


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[NickHK]

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]

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)