£3.95
Introducing DateTimePicker for Excel (previously DatePicker for legacy versions)
Flexible Date Restriction with Single Date Selection from a UserForm Popup Calendar in a Worksheet or from a Textbox on a UserForm for Excel 2016 (32bit or 64bit, Version 16). Now featuring additional Time Picker and various modifications to the UI/Code
DateTimePicker is my latest Draggable, Popup Calendar-style Dialog allowing you to select a single Date or a Date and Time and return it to the Cell. DateTimePicker is built using a standard Excel UserForm. DatePicker is similar to my Popup Calendar Software but doesn't use an embedded image to restyle the Dialog, is more compact and has a different look and feel to it. You can toggle the Months and restrict the Date range to a specific consecutive Day range (ie. Monday to Sunday for the current week), a single Month (October 2021) or a specific consecutive Week range (next 2 weeks). You can use my DatePicker with a UserForm to return a Date to a Textbox control. You can dismiss the DatePicker using the Escape {ESC} key. You can position the DatePicker right next to the ActiveCell in a Worksheet and drag the DatePicker around using the left Mouse Button. DatePicker allows for very flexible Date restrictions ie. allow Mondays only to be Booked for the next 4 Years. There are toggle arrows for the Years and you can left/right-click on the Header to increment the Months. New for version 1.3, Tooltips, Hand Cursor and Scale capability to resize the Dialog on-the-fly. Version 1.4 goes a little deeper into using the DateTimePicker on a UserForm
The purchase includes DateTimePicker versions from v1 through to v1.4 and Popup Calendar
Prerequisites
Microsoft Excel 2016 Version 16 (32bit or 64bit) · designed for Office 365
Basic to moderate Excel Skills and some VBA skills to import Code Modules into own Project if not using the purchased Spreadsheet
Windows PC · NOT a Mac!
No support is provided for customization of this Software
Online Documentation/Help/Features/Credits:
https://www.kubiszyn.co.uk/documentation/datepicker.html
Please note: this Software is released under an MIT license and as such you must attribute the author, Mark Kubiszyn whenever distributing or remixing the work