Change events

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top