Does formatting raise an event

  • Thread starter Thread starter Sandy V
  • Start date Start date
S

Sandy V

Hi

I've noticed several examples in this NG, and elsewhere,
in which events are disabled whilst applying cell formats,
eg code to extend Excel's limit of 3 conditional formats
and apply color.

Does formatting ever raise any events, and if not is there
any reason to disable events if the code only changes
formats?

TIA
Sandy
 
Hi Chip
Thanks for clarifying that,
Sandy
-----Original Message-----
Sandy,

No, changing the format of a cell does not trigger a change event.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com (e-mail address removed)





.
Click to expand...
 
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

Format Painter and Worksheet Change Event 1
Raising Events 1
recognizing conditional formatting with VBA 3
Inconsistent behavior when applying conditional formats 3
Conditional Formatting macro: simple, but doesn't work 6
Raise Event Problem 4
conditional formatting of cells based on result in hidden cell 1
conditional format fails when copied 1

Back
Top