IsText VBA

[mip350]

Just wondering what the VBA wording for "IsText" is? I know for Excel "ISNUMBER" is "IsNumeric" for VBA.

Dave

 

[Travis]

you can do

Sub test()
MsgBox Application.WorksheetFunction.IsText("text here")
End Sub

 

[mip350]

well what I am trying to do is swap the "IsNumeric" statement for the "IsText' command. The VBA works fine with IsNumeric but but not with IsText. The equation is:

If Cells(5, y).Value >= Date And Not IsNumeric(Cells(x, y).Value) Then

 

[Tom Urtis]

If Cells(5, Y).Value >= Date And Application.IsText(Cells(x, Y).Value) = False Then