+ Reply to Thread
Results 1 to 2 of 2

datavalidation

  1. #1
    Registered User
    Join Date
    10-10-2014
    Location
    Ireland
    MS-Off Ver
    2013
    Posts
    37

    datavalidation

    Hi all i am try to use data validation in 2 boxes for start and end date but i want to ensure that once a start date has been selected an end date below the start date cannot be selected. I cant figure it out, any suggestions appreciated. DataValidation.xlsx

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: datavalidation

    Use the green cells (range) for the datavalidation for the enddate.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Datavalidation in different tab
    By Karl Sleeckx in forum Excel General
    Replies: 10
    Last Post: 11-10-2014, 01:59 PM
  2. [SOLVED] DataValidation With Icons
    By mrr2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-28-2013, 11:16 PM
  3. Datavalidation problem
    By rvr ramana in forum Excel General
    Replies: 3
    Last Post: 01-07-2013, 04:55 AM
  4. error on datavalidation
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2009, 04:16 PM
  5. vba help for datavalidation
    By rajeshparikh64 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2006, 10:21 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