Userform Textbox - Date Problem
 

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

Userform Textbox - Date Problem
 

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

-----Original 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/

.

Userform Textbox - Date Problem
 

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/