+ Reply to Thread
Results 1 to 3 of 3

Date picker-Need it to default to today's date. Also getting error but it seems to work.

  1. #1
    Registered User
    Join Date
    02-19-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2013
    Posts
    69

    Date picker-Need it to default to today's date. Also getting error but it seems to work.

    I activated a date picker in excel 2013 for use in my userform. The date picker defaults to the date that I added it, but I'd like to get it to default to today's date instead. I'm assuming that the issue is the value, but I'm unable to find an option that works in that field other than a specific date.
    Capture1.JPG


    It also gives an error when the user form is submitted, but it actually seems to be entering the date where I need it so I've just been ending it and ignoring it.
    It shows this error:
    Capture2.JPG

    and relates it to this code:
    Please Login or Register  to view this content.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Date picker-Need it to default to today's date. Also getting error but it seems to wor

    probably, make that value blank in the datepicker properties, and in the userform initialize event, set the value of the datepicker to todays date.
    You could supply a sample wb with the userform with the datepicker in it.

  3. #3
    Registered User
    Join Date
    02-19-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2013
    Posts
    69

    Re: Date picker-Need it to default to today's date. Also getting error but it seems to wor

    I figured it out. You cannot just leave the box empty. It's connected to a checkbox function. I changed the checkbox to true and then it allowed me to remove the date value.
    Capture3.JPG

    I dont really care for the look of it with the checkboxes in there and it's added seconds to the time, which I don't need, but overall it's functional, so I guess that's irrelevant
    Capture4.JPG

+ 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] Date Picker doesn't work when workbook is reopened
    By TPDave in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-18-2020, 03:22 AM
  2. [SOLVED] Date Picker Default Value
    By jeetkapadia in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2017, 03:13 PM
  3. Replies: 4
    Last Post: 02-03-2017, 10:36 AM
  4. [SOLVED] Date picker - must not be more that 6 yrs from today
    By AuntyJean in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-24-2015, 10:33 AM
  5. Userform: Calender to open with today's date as default
    By Ashali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2012, 07:01 AM
  6. pop up date picker wont work when sheet is protected
    By jamie.c in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-17-2009, 11:28 AM
  7. Default today's date - Excel 2000
    By Abay in forum Excel General
    Replies: 4
    Last Post: 08-25-2005, 12:05 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