Target.Address Doesn't Work in Excel 97?

[JK]

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

[Tom Ogilvy]

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" <[email protected]> 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
>
>

[JK]

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

[Tom Ogilvy]

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