VB Events (Macro triggered by format change in cell)

Y

YS

I am trying to find out if macros can be triggered by
format changes in Excel cells.
Specifically, I am hoping to have a macro activated when
the color for a cell is chenged.

Thanks.
 
J

jeff

Hi,
Because there is no cell color change event, about the
only way to achieve what you want is to write VBA code
to do the checking when any change occurs - and this
would involve keeping track of all your cells' original
(and then newly changed to) colors someplace.

Not sure it would really be worth the effort...

jeff
 
Top