Event for changing color

  • Thread starter Thread starter Stephan Melchior
  • Start date 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
 
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
 
You must log in or register to reply here.

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

Is there a way to protect hidden rows and also change fill color? 1
Event when cursor changes cells, but no select(?) 2
Cell Background Color Change --> Change Event 5
active combobox - possible to configure as display value andcoordinate value? 3
Track color change 3
Font ColorIndex, Ws Change Event 2
Change color of row (Col A thru Col Q) based on text value in Col J 5
sheet event wait for another event? 6

Back
Top