Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch error
The following code tests if the user has input both pieces of data before
proceding with the program. But I'm getting a Type Mismatch error on the IF test. Sub UserInputCheck() frmFacil.Hide sFacilNameUI = frmFacil.tbFacilName.Text On Error Resume Next lFacilRowsUI = frmFacil.tbFacilRows.Value On Error GoTo 0 If sFacilNameUI = "" Or lFacilRowsUI = "" Then <------TYPE MISMATCH ERROR MsgBox "Please enter a both a Facility Name and" & Chr(10) & _ "the number of clients served!", vbOKOnly Call GetFacilName End If End Sub How do I test for no entry on the lFacilRowsUI variable? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
runtime error 13 - type mismatch error in Excel 97 on Citrix | Excel Programming | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |