TEXT BOX TO INPUT DATES IN VBA CODE

Download   Home          

What's new

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

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, and 2010.

Download the English version here    You also can download from this mirror site    Last update: 04/01/2012 - 30.5kb     Freeware based in this License Agreement

More information

Home