+ Reply to Thread
Results 1 to 10 of 10

Office 365 Excel 64 bit Userform Date Picker

  1. #1
    Registered User
    Join Date
    02-23-2014
    Location
    PA, USA
    MS-Off Ver
    Office 365 Insiders
    Posts
    4

    Office 365 Excel 64 bit Userform Date Picker

    Hiyas,

    I have a spreadsheet where there's a field in my table for a date. Currently, I'm entering in the date manually but, I wanted to try my hand at create a userform with VBA and for the date, I wanted a date picker.

    Sadly, I've learned that 64 bit Excel doesn't have a built in date picker. I'm on the Insiders Office 365 version of 64 bit Excel and was hoping that someone could point me in the right direction.

    I've found a few posts about date pickers but they all seem to be a bit outdated. Any guidance would be greatly appreciated!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Office 365 Excel 64 bit Userform Date Picker

    Welcome to the forum!

    First of all, will you please update your user profile? Excel 2019 and Office 365 are NOT the same version (one is standalone, the other subscription - the former will age, the latter will always be up-to-date). Thanks!

    The date picker has not been available in Excel (32 or 64 bit) for some time to my knowledge.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    02-23-2014
    Location
    PA, USA
    MS-Off Ver
    Office 365 Insiders
    Posts
    4

    Re: Office 365 Excel 64 bit Userform Date Picker

    Hiyas!

    Profile has been updated, thank you for pointing that out. I've since upgraded to Office 365 Insiders.

    I've never created userforms before, they look interesting and it's definitely a challenge. I wonder why they've stopped including a date picker.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Office 365 Excel 64 bit Userform Date Picker

    I don't know, but if you Google it you will find lots of disgruntled punters. That said, nobody seems to have rushed to fill the void with a modern version of the same, so there can't be that much call for one. There are several add-ins, but as you say, they all look a little dated.

    What's the scope of dates you need to enter? How far past and into the future do you need to go?

  5. #5
    Registered User
    Join Date
    02-23-2014
    Location
    PA, USA
    MS-Off Ver
    Office 365 Insiders
    Posts
    4

    Re: Office 365 Excel 64 bit Userform Date Picker

    Realistically, I probably don't need a date picker at all and could keep doing what I have been doing. I basically created a table of courses I've been taking and buying on places like Udemy, Eduonix etc. I have about 200 rows now, so nothing real serious.

    Since everything is entered manually in the table, I thought it would be cool to try my hand at learning userforms and creating a data entry form to enter the data instead of just manually entering it into the table. It's really just a timestamp of when I purchase a course. I could probably omit a date picker altogether and add the date with just VBA code.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Office 365 Excel 64 bit Userform Date Picker

    So why not use the shortcut for today's date? Hold down the CTRL key and click on the semi-colon key. Two clicks - all done!

    Don't forget you could add data validation lists to your table. You probably don't need a user form to speed up data entry if the data is going into a simple table.
    Last edited by AliGW; 07-09-2019 at 02:05 AM.

  7. #7
    Registered User
    Join Date
    02-23-2014
    Location
    PA, USA
    MS-Off Ver
    Office 365 Insiders
    Posts
    4

    Re: Office 365 Excel 64 bit Userform Date Picker

    I'll have to give the shortcut a try. I thought about it a few times and forgot what it was and haven't really circled back to look it up. Thank you for suggesting it!

    I also really don't need the user form at all. It was more of a "let me do something overkill but new to learn something" kind of thing. Thanks again, I really appreciate the feedback!

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Office 365 Excel 64 bit Userform Date Picker

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  9. #9
    Registered User
    Join Date
    11-01-2012
    Location
    Toowoomba
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    8

    Re: Office 365 Excel 64 bit Userform Date Picker

    The question was a 64 bit date time picker for a userform

    THat was NOT solved ???????

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Office 365 Excel 64 bit Userform Date Picker

    Quote Originally Posted by harrys View Post
    The question was a 64 bit date time picker for a userform

    THat was NOT solved ???????
    OP was content with the suggestions given.

    If you have your own question, please start your own thread.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Excel - VBA : pass variable from Sub to Userform (Date Picker) Part II
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-27-2017, 01:31 PM
  2. [SOLVED] Excel - VBA : pass variable from Sub to Userform (Date Picker)
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2017, 02:23 AM
  3. Date picker, userform and other problems - Excel for mac
    By dmilanb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2016, 12:53 PM
  4. adapting a downloaded, excel date picker form into my own userform
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2014, 03:50 PM
  5. Date picker control for Excel 2003 userform
    By GreyGhost in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2014, 06:20 PM
  6. Date picker UserForm to stay always in front of the main UserForm
    By Gabor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2014, 07:31 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