I'm still relatively new with macros - my question is as follows

A macro that has is set up as a "Worksheet" - "Change" will trigger anytime
a cell is changed. Can I specifically identify one cell and if this cell's
value changes - then additional logic would occur?

In the event, Target holds a reference to the trigger cell/cells

if Target.count > 1 then exit sub
if Target.Address = "$B$1" then


End if

--
Regards,
Tom Ogilvy


"Brad" wrote:

> I'm still relatively new with macros - my question is as follows
>
> A macro that has is set up as a "Worksheet" - "Change" will trigger anytime
> a cell is changed. Can I specifically identify one cell and if this cell's
> value changes - then additional logic would occur?

I really do appreciate all the help this site provides

Thanks Tom!!

"Tom Ogilvy" wrote:

> In the event, Target holds a reference to the trigger cell/cells
>
> if Target.count > 1 then exit sub
> if Target.Address = "$B$1" then
>
>
> End if
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Brad" wrote:
>
> > I'm still relatively new with macros - my question is as follows
> >
> > A macro that has is set up as a "Worksheet" - "Change" will trigger anytime
> > a cell is changed. Can I specifically identify one cell and if this cell's
> > value changes - then additional logic would occur?