View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lore Leuneog Lore Leuneog is offline
external usenet poster
 
Posts: 4
Default reset Workbook_SheetChange event?

Hello

I'm doing some cell validation on Sheet level within the
Workbook_SheetChange event. Unfortunately the Workbook_SheetChange event
doesn't provide a cancel-argument. When I refocus a wrong entry the user can
leave the cell without triggering the event again (because the cell value is
already changed).
Is there something like an cancel-argument for the sheetchange?

Thank you
Lore

(P.S.: I don't want to delete the wrong entry. I only want the
Workbook_SheetChange event to be triggered until the entry is corrected.)