opposite of IsNumeric

[thephoenix12]

Hi,

I know that IsNumeric returns true if the selection is only numbers
but is there a function that returns true if the selection is all text
Using If Not IsNumeric does not work, because if something contain
text and numbers it returns true, which is what I do not want.

Thanks,

Stev

 

[Tom Ogilvy]

Look at VBA HELP on the LIKE operator.

--
Regards,
Tom Ogilvy




(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

It is not pretty, but if you had only numbers and/or letters and you wanted
to check for at least one number in the string:

Option Explicit
Sub AllText()
Dim i As Integer
Dim TestString As String
TestString = Range("A1")
For i = 1 To Len(TestString)
If IsNumeric(Mid(TestString, i, 1)) Then
MsgBox ("Not text")
Exit For
End If
Next i
End Sub