Would this work?

VB Code:
  1. Private Sub Form_Load()
  2. GetType "1231ABC"
  3. End Sub
  4. Private Sub GetType(StrVal As Variant)
  5. If IsNumeric(StrVal) Then
  6.     MsgBox "Is a number"
  7. Else
  8.     MsgBox "Is a string"
  9. End If
  10. End Sub