Create customs define event
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/ |
Create customs define event
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/ |
All times are GMT +1. The time now is 11:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com