The Ultimate Excel Date Picker


The Ultimate Excel Date Picker by Mor Sagmon


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!

Excel date picker

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.


There are no reviews yet.

Be the first to review “The Ultimate Excel Date Picker”

Your email address will not be published. Required fields are marked *