How do I create a customer event in worksheet, where trigger by changing
cell format eg:cell font bold or font been underline.

thk
phang



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

There are no events that trigger when these actions are taken. I don't
believe there is a way to create a custom event that would trap them. Maybe
you could work up something in the selectionchange event to gather data on
the cell selected, then on the next change, make a comparison to it current
state to see if anything has changed.

--
Regards,
Tom Ogilvy

"phang" wrote in message
...
How do I create a customer event in worksheet, where trigger by changing
cell format eg:cell font bold or font been underline.

thk
phang



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/