LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.)


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Workbook_SheetChange for single column Brad K. Excel Programming 2 January 25th 05 07:07 AM
Workbook_sheetChange event J S Excel Programming 0 August 9th 04 07:16 PM
workbook_sheetchange JulieD Excel Programming 1 June 14th 04 04:32 AM
Problem with the Workbook_SheetChange event??? angel Excel Programming 0 January 29th 04 02:56 PM
Workbook_SheetChange will not fire Robert Willard Excel Programming 1 September 10th 03 07:52 PM


All times are GMT +1. The time now is 07:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"