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: 39
Default validating dates on a userform

I have two text boxes on a user form, one start date and one end date. My
problem is that I need the right code for applying the validation to the text
boxes. They must fit the following criteria:

1. The start date can't be greater than the end date, and vice versus.
2. The dates entered in both fields can only be within a specific range of
dates (7/1/2009 through 7/31/2011). So the user won't be allowed to enter any
dates before or after this specific range.

If anyone has an idea please let me know.

Thanks,
~Gabe
 
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
Validating Required Fields in Userform robinsn Excel Discussion (Misc queries) 0 July 24th 10 02:16 PM
Validating dates in a cell BrianG[_3_] Excel Programming 3 May 15th 07 10:06 PM
Validating Dates Entered patam Excel Discussion (Misc queries) 2 September 2nd 05 05:36 PM
Validating Dates Luis Verme Excel Programming 22 July 10th 05 11:41 AM
Event validating two ranges with dates G R E G Excel Programming 1 August 9th 03 12:03 AM


All times are GMT +1. The time now is 08:13 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"