• Home
 · 
• String Manipulation
 · 
• Determine / Prevent users from entering Numbers or Alpha Characters

Determine / Prevent users from entering Numbers or Alpha Characters

Determine / Prevent users from entering Numbers or Alpha Characters

Rate Determine / Prevent users from entering Numbers or Alpha Characters

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

' [email protected] (Don't Email my ass)


Sub CheckString (strTest as String)
'Be sure to pass the string to test...
'i.e. Call CheckString Text1.Text

'Replace Msgbox with other code if you like

   If IsNumeric(strTest) = True Then 
        Msgbox "String Value Passed is Numeric"
   End If
   If IsNumeric (strTest) = False Then
        Msgbox "String Value Passed is Alpha"
   End If
End Sub