+ Reply to Thread
Results 1 to 19 of 19

Calendar form or date picker

  1. #1
    Forum Contributor
    Join Date
    01-02-2020
    Location
    Idaho, USA
    MS-Off Ver
    365
    Posts
    273

    Calendar form or date picker

    Hi all,

    So has anyone here built a form that can be used as a date picker that I could steal from them?.. or know where I can get a date picker or calendar control since Office 365 no longer has one. I could build one, but it's a lot of work getting all the days of the weeks right for every month and every year and then displaying them all in the right place on a form that I don't want to do.. lol Just thought I'd ask if I could steal one from someone before I go and build one. It has to be on a form though so I can use it in multiple Excel files.
    That would be super awesome and I would be very grateful!

    Thanks!

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Calendar form or date picker

    Here is one I saved.
    Unfortunately, I don't know who manufactured it so I can't say thanks.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor unit285's Avatar
    Join Date
    10-29-2015
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    358

    Re: Calendar form or date picker

    This is one I use at times
    Attached Files Attached Files

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Calendar form or date picker

    attached my version - fully configurable.
    double-click column A or B
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  5. #5
    Forum Contributor
    Join Date
    01-02-2020
    Location
    Idaho, USA
    MS-Off Ver
    365
    Posts
    273

    Re: Calendar form or date picker

    unit285:
    Yours used the Monthview control, hence the reason I made this post. That's what I was using before too and it worked great! But it doesn't work in Office 365 which sucks. It doesn't recognize that control.. but it's Microsoft.. what do you expect? But don't think I don't appreciate the the time you took to reply and try to help me. Thank you very much!

    jolivanes and torachan:
    Both of yours will work great! There's things I really like about both of them that they don't both do. I really like the colored weekends and the next & previous months date that show in jolivanes, and I really like the next and previous month arrows in torachan's. I think I'm going to try to combine the 2 to have both. If I don't succeed then it's going to be tough to decide which one to use... lol

    This was sooo helpful more than you know! It saved me a LOT of time! Thank you all so much! I will close this question and give credit where credit is due.

  6. #6
    Valued Forum Contributor unit285's Avatar
    Join Date
    10-29-2015
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    358

    Re: Calendar form or date picker

    I also use Office 365 and it works fine for me. You might need to register a mscomct2.ocx file.

    1. - Download the attached file, I had to change the file extension to "xls" so I could upload it here. It is not an excel file so don't try to open it. Change the file's extension back to "ocx" before proceeding to step 2.
    2. - Put mscomct2.ocx into the following directory.
    Please Login or Register  to view this content.
    3. - Open an elevated CMD prompt (search for CMD in the start menu, right-click on it and select Run as Administrator) and run the following command.
    Please Login or Register  to view this content.
    4. - Try running the Monthview control again.
    Attached Files Attached Files

  7. #7
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Calendar form or date picker

    Found another one.
    See attached
    Attached Files Attached Files

  8. #8
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Calendar form or date picker

    And another - mine with time facility as well.
    Add new reference in column A - click in col B - to insert/change time with hours/minutes highlighted spinner will adjust - then click date.
    The userform will follow the table only.
    And mine with coloured weekends - click in column 'A'
    Attached Files Attached Files
    Last edited by torachan; 09-19-2021 at 03:22 AM.

  9. #9
    Forum Contributor
    Join Date
    01-02-2020
    Location
    Idaho, USA
    MS-Off Ver
    365
    Posts
    273

    Re: Calendar form or date picker

    Thanks again everyone! Again some hard choices. I checked them all out. They are all very good! I went with jolivanes Calendar9 A. It does everything like I like and was the simplest and all the code is contained in the form. I made a few changes so I don't have to click the "Insert date" button. Now it inserts the date as soon as you pick a date. It's all up and running good in my old Excel app now. You people are amazing and I thank you very much!!

  10. #10
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Calendar form or date picker

    Thank you for letting us know, good luck and stay safe.

  11. #11
    Registered User
    Join Date
    03-30-2022
    Location
    Abuja
    MS-Off Ver
    Windows 10
    Posts
    1

    Re: Calendar form or date picker

    Hi achammar, can you kindly share your modified version of Calendar9?

  12. #12
    Forum Contributor
    Join Date
    01-02-2020
    Location
    Idaho, USA
    MS-Off Ver
    365
    Posts
    273

    Re: Calendar form or date picker

    Nnamdee_E

    Here is an Excel file with the calendar form in it. You can export it and import it back into another file or drag it into another file using Object explorer or whatever. Right now there is code in the selection change event to show the form if you click in any cell in column C. Then just click the date you want and it will be entered into the active cell.
    Attached Files Attached Files

  13. #13
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Calendar form or date picker

    attached updated version - repetitious code is eliminated by using a class module to intercept the button press - format date to suit in this module.
    double click in columns 'A' or 'B' - this enables you on a single click to remove date if you wish.
    Attached Files Attached Files

  14. #14
    Forum Contributor
    Join Date
    01-02-2020
    Location
    Idaho, USA
    MS-Off Ver
    365
    Posts
    273

    Re: Calendar form or date picker

    That is very nice torachan... I like that

  15. #15
    Registered User
    Join Date
    09-01-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    96

    Re: Calendar form or date picker


  16. #16
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Re: Calendar form or date picker

    I know that this topic is solved, but I would like to share what I think is the best calendar, wich also can be used in UserForms.

    not many know Erlandsen Data Consulting from Norway, but he has so many cool things.
    Check out his website where you can download all his stuff
    https://www.erlandsendata.no/?t=vbat...ch&p=3780#main
    Attached Files Attached Files

  17. #17
    Registered User
    Join Date
    08-02-2021
    Location
    South Africa
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Calendar form or date picker

    This is nice! Possible to substitute active cell for text box in a userform?

  18. #18
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413
    Quote Originally Posted by MyForcey View Post
    This is nice! Possible to substitute active cell for text box in a userform?
    No problem, I Will uploade my version for userforms on Tuesday when I am back

  19. #19
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Calendar form or date picker

    calendar to userform textboxes
    Attached Files Attached Files

+ 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] Need Date picker form to replace calendar
    By A9kurs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2019, 02:34 AM
  2. [SOLVED] Date picker calendar value is empty?
    By RustyNail in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2019, 02:36 PM
  3. Setting date picker date and having 2 columns to each date for excel calendar
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2017, 11:13 PM
  4. [SOLVED] Date picker calendar
    By dori2o in forum Excel General
    Replies: 3
    Last Post: 12-08-2017, 10:45 AM
  5. Date Picker / Calendar for Combobox
    By sthiru in forum Excel General
    Replies: 9
    Last Post: 11-24-2015, 04:30 PM
  6. [SOLVED] Calendar Option in the user form - date picker
    By skhari in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2012, 02:46 AM
  7. [SOLVED] mscmctl2.ocx ... calendar and date picker sometimes not available
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2005, 08: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