Save Between 10 to 30 Minutes a Day with
The Ultimate Excel Date Picker
CONFIGURABLE: popup method, first day of the week, auto-tab, and more
BRANDABLE: 8 pre-designed themes to chose from, or fully customize to your brand
MULTI-PURPOSE: Works with User Forms and Worksheet Cells
✔ Brand with your own colors
8 professionally designed themes to chose from.
Almost every element of the Date Picker can be set with the color of choice:
- Header background
- Navigation and drop-down controls background
- Weekend days background
- Weekdays background
- Weekdays font
- Today's background
- Today's font
✔ Use with Worksheet cells containing dates
Configure for auto-popup or for in-cell button*
Auto best-fit positioning of the Date Picker next to the date cell
Date Picker title bar can be shown to allow manual re-positioning
* Auto-popup only for password-protected Worksheets
✔ Use with User Forms
Complete the professional and friendly user experience you design with the auto-popping Date Picker
Auto best-fit positioning of the Date Picker next to the date cell
Supports the date format you need: 23/05/2023, 05/23/2023, 23-May-2023, 2023-05-23 or other
✔ Configure the Date Picker behavior to your needs
Works with Right-To-Left and Left-To-Right User Forms and Worksheets
Set the years offset to limit the drop-down list of years to the bounds you need
Set the first day of the working week
Configure auto-tab to the next cell upon selecting a date
The Date Picker VBA code is open for you to further adjust and develop!
And now...
When you invest in the Ultimate Excel Date Picker, you also get 15% percent off my flagship course: Computer Programming with Excel VBA.
This alone will more than pay for the Excel Date Picker...
David Boffa, Australia
"Just wanted to say thank you for the effort and work that would have gone into creating such a complete and all round calendar date picker.
I can see that this has been designed with the user in mind, from considering the multiple versions of excel the user may be working with to even what operating system is being used, your date picker caters for it all.
I have learned a few neat bits of code through the well explained comments in the code as well which allows the user to customize how it looks from selecting themes to even inputting your own colors, very cool !
A very clever tool and thank-you for sharing ."
Easy installation and setup - 1 minute to see the beautiful Date Picker in your project!
1. Open the VBA Editor (ALT+F11) from your Excel Workbook
2. Import (CTRL+M) the two files you received: DatePicker.bas and DatePickerForm.frm
3. Copy/Paste a small code snippet to any Worksheet module / User Form
Get this attractive Date Picker - another GREAT product by Mor Sagmon
A small investment for lifetime, and you will never want to type dates again.
Can I use the Date Picker in commercial Excel projects I sell to my customers?
Do I need to know VBA in order to install the Date Picker?
Does the Date Picker supports other languages?
What Excel versions are supported? how about Mac? Any limitations?
How will the Date Picker affect my Excel Workbook?
How is my privacy kept when using the Date Picker?
It's a "no-brainer"
No recurring payments, no strings attached, no small letters.