Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This works
Private Sub txtbxPhonePost_Exit(ByVal Cancel As MSForms.ReturnBoolean) If txtbxPhonePost.Value = "" Then usfDemo.cmbxDOBMonth.SetFocus Else If IsNumeric(usfDemo.txtbxPhonePost.Text) = False Then MsgBox "This box must be blank or contain exactly 4 numbers!", vbOKOnly Else If Len(usfDemo.txtbxPhonePost.Text) < 4 Then MsgBox "This box must be blank or contain exactly 4 numbers!", vbOKOnly End If End If End If End Sub Is there a better way? -- Thanks Shawn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Character limit in textbox | Excel Worksheet Functions | |||
Limit Number in cell to 5 Digits | Excel Discussion (Misc queries) | |||
Limit the amount of digits displayed in a field in Excel or Access | Excel Discussion (Misc queries) | |||
Limit Digits entered into a cell | Excel Discussion (Misc queries) | |||
in excel, how to limit digits of negative hexadecimal numbers? | Excel Discussion (Misc queries) |