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

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

<[email protected]> wrote in message
news:[email protected]...
> 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
>

You mean

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"NickHK" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
> <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> You mean
>
> Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range).
>
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "NickHK" <[email protected]> wrote in message
> news:%[email protected]...
> > 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
> >
> > <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
> >
> >
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > You mean
> >
> > Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range).
> >
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "NickHK" <[email protected]> wrote in message
> > news:%[email protected]...
> > > 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
> > >
> > > <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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
> > > >
> > >
> > >
> >
> >
>
>