+ Reply to Thread
Results 1 to 3 of 3

checking two dates on user form

  1. #1
    Registered User
    Join Date
    08-25-2013
    Location
    Epsom
    MS-Off Ver
    2013
    Posts
    59

    checking two dates on user form

    Hi all, I've got two text boxes where users input the dates in specified format (dd/mm/yyyy). current validation checks whether one date is not earlier than the other one and it looks like this:

    Code:
    Please Login or Register  to view this content.
    however if they are equal which suits me I am still getting an error. any way around it? thanks
    don't need a calendar btw
    Rome wasn't built in a day

  2. #2
    Forum Contributor
    Join Date
    01-30-2013
    Location
    Wales
    MS-Off Ver
    Excel 2013
    Posts
    231

    Re: checking two dates on user form

    Change ">" to ">="
    Click * below if this answer helped

  3. #3
    Registered User
    Join Date
    08-25-2013
    Location
    Epsom
    MS-Off Ver
    2013
    Posts
    59

    Re: checking two dates on user form

    thanks that worked

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] validating to and from dates in user form
    By tomanton in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2014, 07:46 AM
  2. [SOLVED] Search and Update Records in User Form changing dates to US Format in Spreadsheet
    By JTResearch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2013, 06:48 AM
  3. Code error in blank text boxes checking and saving in user form
    By jwala in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-03-2010, 08:19 AM
  4. Checking for User Form loaded
    By scottintexas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2008, 02:58 AM
  5. Checking the status of a checkbox in a user form
    By Peter Rooney in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-01-2005, 04:09 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1