A Userform Text
Box programmed to facilitate and restrict the input of dates in
Microsoft® Visual Basic® for Application (VBA) code.
items in this page:
- Only accept
typing of numbers
- Auto inserts and always shows separators according to the format
- Can foresee some logical typing
- Can correct any illogical typing
- Ilogical end of a month is corrected in the proper month not trying
to resolve in possible format types like VBA Cdate and DateValue
functions do. For example: 02/31/05 is corrected to 02/28/05 not
- Works fine with any date separator
- Accepts all date numeric format: dd/mm/yy, mm/dd/yy, mm/yy/dd,
yy/mm/dd, mm/dd/yyyy, mm/yyyy/dd, yyyy/mm/dd e yyyy/dd/mm
- Prepared to call the Excel Calendar, if it is loaded (You can
get ExcelCalendar.xla file in the link below, it's free) http://orlando.mvps.org/#Calendar
- Ready to be used on your VBA project.
Tested in Excel for Windows, versions 97, 2000, 2002(XP), 2003,
2007, 2010 (32 and 64-bit), 2013 (32 and 64-bit), 2016 (32 and 64-bit), and 2019 (32 and 64-bit) in MSI-based and Click-To-Run installations of
Office 365™ cloud-based services.