Hello:
I have read numerous posts in this forum regarding installing the 32-bit Date Picker for Excel 2016. I don't understand why Microsoft doesn't make it a standard release with Excel 2016? I want to use it, not only for a worksheet, but also for an Excel Userform. I distribute my applications to my clients and apparently they would need to also install it on their systems to use my Excel application. What was Microsoft thinking!! It is one of the most useful features that they have made difficult to install and distribute. I tried the Outlook version in Excel and it didn't work. Any EASY suggestions for an application that I will distribute. It shouldn't be this difficult.
Date Picker Excel 2016 32-bit
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Date Picker Excel 2016 32-bit
The date picker is part of VB6, not of Office. It would have been nice if Microsoft included one in Office (as they did in the past), but alas...
You might use the Calendar Control for All Office versions - including Office 2016 64 bit (With Advanced Features). It is built entirely from "native" userform controls.
The article explains how to incorporate it into a userform in your workbook:
- Import the cCalendar class module
- Add a Frame control to your userform
- Use code in the UserForm_Initialize event procedure to add the calendar to the frame
You might use the Calendar Control for All Office versions - including Office 2016 64 bit (With Advanced Features). It is built entirely from "native" userform controls.
The article explains how to incorporate it into a userform in your workbook:
- Import the cCalendar class module
- Add a Frame control to your userform
- Use code in the UserForm_Initialize event procedure to add the calendar to the frame
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 165
- Joined: 03 Oct 2015, 00:30
Re: Date Picker Excel 2016 32-bit
Thanks Hans. Since it is available in Access, I thought it would also be included in Excel.
Rich
Rich
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Date Picker Excel 2016 32-bit
The date picker in recent versions of Access is not a separate control. It is automatically displayed next to date fields and text boxes.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 165
- Joined: 03 Oct 2015, 00:30
Re: Date Picker Excel 2016 32-bit
Hans... It seems that Access has the correct way of handling the date picker. Not sure why the Excel development staff didn't include it.
Regards,
Rich
Regards,
Rich
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Date Picker Excel 2016 32-bit
Excel is not strongly typed like Access, so it would be more difficult to implement in Excel.
Best wishes,
Hans
Hans