ExcelBanter - Event for changing color

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Event for changing color (https://www.excelbanter.com/excel-programming/306062-event-changing-color.html)

Event for changing color

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

Event for changing color

Hi stephan

there's no such event in Excel
Frank

-----Original Message-----
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
.

Event for changing color

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

Stephan Melchior wrote:

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