VB Events (Macro triggered by format change in cell)

  • Thread starter Thread starter YS
  • Start date Start date
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.
 
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
 

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

Similar Threads

Trigger Event on Format Change 4
Excel Macro to automatically go to the right of the last colored cell 0
Find and Replace variable string 11
Trigger Macro by Worksheet_Change 5
Event Trigger - EXCEL VBA 3
Macro for a one time triggered copy of cell value 8
VBA Excel partial cell compare to another cell 0
Run a macro based on a cell value 1

Back
Top