|
|||||
|
This utility is a COM add-in programmed in Microsoft® Visual Basic® for Application (VBA) that makes easy date and decimal number entry in Microsoft® Excel® format cell. See the pictures below. It consists of only one file, the CellEasyEntry.dll, which is about 95 kb in size and can be installed automatically using one of the installer package files available below to download. Except for the DLL, no other setting is saved in the Microsoft® Windows® Register. Its setting is saved in CellEasyEntry.ini file that is created and maintained by the proper utility. You also can uninstall it automatically using the same installer file, leaving no mess on your Windows Register or disc. Features:- Permits only numbers typing - Auto inserts and always shows separators according to the format - Can foresee some logical typing - Can correct any illogical typing - llogical 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 - Auto activates when selecting or double clicking unlock cells with date or decimal number formats - You will perceive immediately how it becomes easy to enter dates and decimal numbers, but maybe you wouldn’t perceive any difference in Excel interface, if it doesn’t put deliberately a little blue mark on the middle of lower border of the cell cursor - There aren’t menu commands and nor tool buttons. To disable or change its setting, press Alt key and click on a cell with date or decimal number format or enter with CellEasyEntry in the cell - Although the deactivation is very easy, it only activates itself yet in zoom of 100% (Note: I’m not so certain if this restriction is a good option, if you dislike, please, email me) - If you have an Popup Calendar for Excel recent version installed, the little blue mark become red and, if it’s clicked, pop up the Calendar. Similar behavior for the Popup Calculator for Excel. Tested in the Microsoft Excel 2000, 2002(XP), 2003, 2007, and 2010.
Pictures:
|
|||||
|
|
|||||