Event for changing color

  • Thread starter Stephan Melchior
  • Start date
S

Stephan Melchior

Servus,

is there an event (callbackmethod) in Excel97 VBA that is fired if
someone changes only the color of a cell. The content is NOT changed!

Greetings
Stephan
 
J

Jerry W. Lewis

More generally, no events are triggered by any formatting changes.

You might be able to fake it using the SelectionChange event. On every
selection change, compare the current formatting of the previous
selection to the previously stored formatting of that selection, then
statically store the the current selection and relevant formatting from
currently selected cells. This could slow response time.

Jerry
 
Top