The Ultimate Excel Date Picker
$9
The Ultimate Excel Date Picker by Mor Sagmon
CONFIGURABLE, BRANDABLE, WORKS ON USERFORMS AND WORKSHEET CELLS
What you’ll get:
- An Excel Welcome + DEMO Workbook
- A PDF Installation Guide including detailed configuration instructions
- Three VBA files to save on your computer and upload to any Excel Workbook you want the Date Picker on
- A 15% discount voucher to my flagship course: Computer Programming with Excel VBA
- Life-time access to the Date Picker product page, for the latest product release and instructions.
This is a one-time purchase, not a recurring payment. The Date Picker is yours for LIFE!
Create your account here to unlock your access to the Date Picker product page for LIFE.
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!
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 .
- David Boffa, Australia
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
Download the full Date Picker Installation guide by clicking here.
Reviews
There are no reviews yet.