Userform Textbox - Date Problem

[universal]

Hello All,

Im currently trying to "Validate" a user form that Ive used before bu
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
number or not (using IsNumeric) though there is nothing that stops a
entry of 38:30:00, or similar, which causes me plenty of headache
later on.

Is there any way I can validate the TextBox to ensure that numbers ar
entered in the format - 38.50 (TensUnits.TenthsHundreths)?

If it makes any difference, the Userform doesnt paste to the Workshee
until a button is pressed

Many thanks in advance,

Eddi

 

[Patrick Molloy]

IsNumeric would be false for 10:30 and true for 10.5

If you use the textbox's Exit method to test for this you
can use

Cancel = NOT(Isnumeric(textbox1))or an IF statement to
display some message.

Patrick Molloy
Microsoft Excel MVP

 

[ZootRot]

Is there a MaskEdit textbox addin in VBA?