| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell change events | Excel Discussion (Misc queries) | |||
| Worksheet Change Events | Excel Programming | |||
| Worksheet Change Events | Excel Programming | |||
| Understanding change events | Excel Programming | |||
| Multiple change events on same sheet | Excel Programming | |||
Linear Mode
