Is there a MaskEdit textbox addin in VBA?
"universal" wrote in message
...
Hello All,
Im currently trying to "Validate" a user form that Ive used before but
had problems.
Its part of a Clocking-In process that measures time spent at work.
The users of the form are asked how many hours they worked.
At the moment the validation checks whether the Textbox contains a
number or not (using IsNumeric) though there is nothing that stops an
entry of 38:30:00, or similar, which causes me plenty of headaches
later on.
Is there any way I can validate the TextBox to ensure that numbers are
entered in the format - 38.50 (TensUnits.TenthsHundreths)?
If it makes any difference, the Userform doesnt paste to the Worksheet
until a button is pressed
Many thanks in advance,
Eddie
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/