LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lee Lee is offline
external usenet poster
 
Posts: 33
Default Delete Key Error Message

*please excuse this if it is a duplicate post. I received an error message on the first attempt

The code below works fine to check a target range against a Start_Date cell except for one thing. If a bad date is entered, I get the error message, but I also get the error message when I enter the delete key to clear the cell contents. Is there any to prevent the error message from displaying every time I enter delete to clear the cell? I've been trying Validation.IgnoreBlank but cannot seem to find the right combinatio

If Intersect(Target, rng2) Is Nothing The
Application.EnableEvents = True: Exit Su
Else
Start_Date = CDate(Cells(3, 9)
If Intersect(Target, rng2) < Start_Date The
MsgBox ("Incorrect Date - Outside of WBS Date Range"
End I
End If
 
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
Message Box: Delete row x? Tami Excel Worksheet Functions 3 July 5th 09 06:59 PM
using VBA how can I delete a worksheet w/o the warning message pop Jim K.[_2_] Excel Discussion (Misc queries) 2 July 1st 08 04:00 PM
Confirm Delete Message Disable RiosPapa New Users to Excel 2 October 7th 05 09:02 PM
changing the message in an error message The Villages DA Excel Worksheet Functions 2 February 18th 05 05:30 PM
How do I get rid of "Compile error in hidden module" error message David Excel Discussion (Misc queries) 4 January 21st 05 11:39 PM


All times are GMT +1. The time now is 06:51 AM.

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"