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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com