Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Format for Userform TextBox | New Users to Excel | |||
Need A date Mask format for a Textbox on UserForm | Excel Discussion (Misc queries) | |||
userform textbox | Excel Worksheet Functions | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Help with Syntax UserForm TextBox | Excel Programming |