Thread: Change events
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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?