+ Reply to Thread
Results 1 to 5 of 5

Date validation drop down box

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Date validation drop down box

    Hi


    I set a drop down box in Cell B1 and for some reason I get a result of #VALUE!. Sample attached. I think the reason is because the length of the first selected is long.

    How can I reset the code below:

    Please Login or Register  to view this content.
    Thank you.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Date validation drop down box

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

  3. #3
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Date validation drop down box

    Sorry
    What do I need to do?
    Do I need to make this unsubscribe or the other forum?

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Date validation drop down box

    Your response leads me to believe you did NOT do what was asked in post #2, which is click a link and read. I can't imagine after reading the page linked above you would not know what to do.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  5. #5
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Date validation drop down box

    ok... got it.

+ 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] Data validation - drop down list - latest date
    By dunnobe in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-14-2017, 06:25 AM
  2. Replies: 1
    Last Post: 05-20-2017, 10:29 AM
  3. Replies: 4
    Last Post: 10-28-2015, 12:59 PM
  4. Replies: 4
    Last Post: 05-17-2012, 04:40 PM
  5. Autocomplete Date Validation List drop-down
    By adds007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2011, 02:06 PM
  6. Date validation drop down
    By kbussen in forum Excel General
    Replies: 5
    Last Post: 12-21-2006, 04:34 PM
  7. Validation, how to see "today" date on top of the drop down list?
    By Hoshyar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-18-2005, 11:02 AM

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