| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to run an event upon changing the value of a specific cell? | Excel Worksheet Functions | |||
| Changing sheets after the DeActivate Event. | Excel Discussion (Misc queries) | |||
| Change row color on event | Excel Discussion (Misc queries) | |||
| click event for changing cell color | Excel Programming | |||
| Changing Event Subs of Controls On Air | Excel Programming | |||
Linear Mode
