TEXT BOX TO INPUT DATES IN VBA CODE

What's new   Download   Home 

A Userform Text Box programmed to facilitate and restrict the input of dates in Microsoft® Visual Basic® for Application (VBA) code.

Following items in this page:

Features

Download

Pictures

Features:

- 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 02/05/1931
- 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.

Download:

Tested in Excel for Windows, versions 97, 2000, 2002(XP), 2003, 2007, 2010 (32 and 64-bit), 2013 (32 and 64-bit), and 2016-24 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365™ cloud-based services.

Download the English version here    You also can download from this mirror site    Last update: 12/23/2023 - 37.1kb     Freeware based in this License Agreement

More information

Home