Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Painter and Worksheet Change Event
Hello,
Why does Applying Formats to a Cell using the Format Painter raise the Worksheet_Change event whereas regular formatting of Cell does not? Doesn't seem consistent. Is there a way to detect that the Change was not actually a cell value change when using the Format Painter? Thank you Gap. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Painter and Worksheet Change Event
"Gap" wrote in message
oups.com... Why does Applying Formats to a Cell using the Format Painter raise the Worksheet_Change event whereas regular formatting of Cell does not? Doesn't seem consistent. Is there a way to detect that the Change was not actually a cell value change when using the Format Painter? Hi Gap, The format painter just copies the range you're one when you click it and then automatically does a Paste Special/Formats on the next range you select. Doing any kind of Paste fires the Worksheet_Change event on the worksheet where it occurred. I don't know of any simple way to determine wither a cell value actually changed or whether something like a Paste Special/Formats fired the event. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trigger Event on Format Change | Excel Discussion (Misc queries) | |||
Worksheet Change event | Excel Discussion (Misc queries) | |||
Worksheet Change Event | Excel Discussion (Misc queries) | |||
Worksheet Change event | Excel Programming | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |