Change events

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top