Change events
 

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?

Change events
 

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?

Change events
 

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?