Thread: msg box and or sheet events
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default msg box and or sheet events
Hi Paul
AFAIK there is no event which is triggered by a format change

--
Regards
Frank Kabel
Frankfurt, Germany

paul wrote:
I want to trigger an event by changing the format(we
change the fill colour) of a cell.The change event isnt
triggered by changing the fill colour.Other wise i can
prompt the user with a msg box to select a range but excel
is frozen while the msgbox appears.
Reply With QuoteReply With Quote