| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| Problems with callback from DLL invoked from VBA | Excel Programming | |||
| Using Excel to handle Com callback procedures | Excel Programming | |||
| RTD Callback and CIS with firewall | Excel Programming | |||
Linear Mode
