Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Target.Address Doesn't Work in Excel 97?
I want worksheet_change to fire a macro only when a specific cell is
changed. In XP, Target.Address="$A$1" works to identify the cell being changed. But in Excel 97 it doesn't. Does anyone know what will work in Excel 97 and Excel XP? Thank you in advance. Jim Kobzeff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Target.Address Doesn't Work in Excel 97?
It has been working for me since 1997.
Perhaps the Change event isn't being fired. Are you updating the cell using a Data Validation dropdown - if so, then if the source data is from a worksheet range, there is your Huckleberry. That situation didn't trigger a change event in xl97. -- Regards, Tom Ogilvy "JK" wrote in message news:p%_Ze.4311$211.4252@trnddc08... I want worksheet_change to fire a macro only when a specific cell is changed. In XP, Target.Address="$A$1" works to identify the cell being changed. But in Excel 97 it doesn't. Does anyone know what will work in Excel 97 and Excel XP? Thank you in advance. Jim Kobzeff |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Target.Address Doesn't Work in Excel 97?
Thank you, Tom. Yes, I am trying to update thru Data Validation. I have
since learned that 97 doesn't do, and the subject cell must be linked to another cell and the macro must be fired with worksheet_calculate. However, I have another Validate Data cell on the same WS that must fire another macro. Is it possible to write it so the second macro doesn't fire the first macro and vice versa? Thank you in advance. Jim Kobzeff "Tom Ogilvy" wrote in message ... It has been working for me since 1997. Perhaps the Change event isn't being fired. Are you updating the cell using a Data Validation dropdown - if so, then if the source data is from a worksheet range, there is your Huckleberry. That situation didn't trigger a change event in xl97. -- Regards, Tom Ogilvy "JK" wrote in message news:p%_Ze.4311$211.4252@trnddc08... I want worksheet_change to fire a macro only when a specific cell is changed. In XP, Target.Address="$A$1" works to identify the cell being changed. But in Excel 97 it doesn't. Does anyone know what will work in Excel 97 and Excel XP? Thank you in advance. Jim Kobzeff |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Target.Address Doesn't Work in Excel 97?
You would need to store the values of the cells and react only if the value
changes since the calculate event does not tell you which cell triggered the event. -- Regards, Tom Ogilvy "JK" wrote in message news:ll2_e.4350$211.3014@trnddc08... Thank you, Tom. Yes, I am trying to update thru Data Validation. I have since learned that 97 doesn't do, and the subject cell must be linked to another cell and the macro must be fired with worksheet_calculate. However, I have another Validate Data cell on the same WS that must fire another macro. Is it possible to write it so the second macro doesn't fire the first macro and vice versa? Thank you in advance. Jim Kobzeff "Tom Ogilvy" wrote in message ... It has been working for me since 1997. Perhaps the Change event isn't being fired. Are you updating the cell using a Data Validation dropdown - if so, then if the source data is from a worksheet range, there is your Huckleberry. That situation didn't trigger a change event in xl97. -- Regards, Tom Ogilvy "JK" wrote in message news:p%_Ze.4311$211.4252@trnddc08... I want worksheet_change to fire a macro only when a specific cell is changed. In XP, Target.Address="$A$1" works to identify the cell being changed. But in Excel 97 it doesn't. Does anyone know what will work in Excel 97 and Excel XP? Thank you in advance. Jim Kobzeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Target.Address in Excel 98 | Excel Discussion (Misc queries) | |||
Target.Address syntax | Excel Worksheet Functions | |||
Worksheet_change Target Address is Reference Cell | Excel Programming | |||
Worksheet_change Target Address is Reference Cell | Excel Programming | |||
target address | Excel Programming |