locked
Date Picker for Excel 2016 64-Bit RRS feed

  • Question

  • Hello:

    I held off a long time before I installed the 64 bit version of Excel on one of my workstations.  Is there still no Date Picker for VBA to call?

    Regards,


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Friday, July 10, 2020 7:48 PM

Answers

  • To:  Rich Locus
    re:  vba access to calendars

    No VBA access that I know of.
    One can also start the application by entering the worksheet function "=PickYourDate()" in a worksheet cell.
    The calendar code is in the UserForm (non modal) module.  It is run from Sub CmdButtonReset_Click().

    Pressing the Ctrl key or Shift key and clicking the Reset button generates the month or year calendar.
    Hope you give it a try.

    NLtL

    • Marked as answer by RichLocus Saturday, July 11, 2020 7:06 PM
    Saturday, July 11, 2020 3:27 AM

All replies

  • To:  Rich Locus
    re:  64 bit date picker

    You could try my "GetYourOwnDate" date picker add-in.
    It is coded for 32/64 bit, but I have no feedback re 64 bit.

    The date picker, besides entering a date,
      can undo up  to 20 entries
      can append dates to existing cell text,
      can insert a month or year calendar.
    It works off the cell right-click menu.
    '---

    '---

    It is free, download from MediaFire (no ads)...
    http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

    Friday, July 10, 2020 10:48 PM
  • Hello:

    Does GetYourOwnDate allow a VBA access?  I always create calendars as part of the VBA process.

    Thanks,

    Saturday, July 11, 2020 2:25 AM
  • To:  Rich Locus
    re:  vba access to calendars

    No VBA access that I know of.
    One can also start the application by entering the worksheet function "=PickYourDate()" in a worksheet cell.
    The calendar code is in the UserForm (non modal) module.  It is run from Sub CmdButtonReset_Click().

    Pressing the Ctrl key or Shift key and clicking the Reset button generates the month or year calendar.
    Hope you give it a try.

    NLtL

    • Marked as answer by RichLocus Saturday, July 11, 2020 7:06 PM
    Saturday, July 11, 2020 3:27 AM