b TEXT BOX TO INPUT DATES IN VBA CODE

Download   Home  Ads        

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, 2010 (32 and 64-bit), 2013 (32 and 64-bit), and 2016 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365™ cloud-based services.

Download

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

 

More information

Home

 





gplus

 

 

Visitas acumuladas em todas as páginas:
Visitas hoje só nesta página: