=ISNUMBER(A3) in Worksheet Formulas, but
IsNumeric(argument) in VBA


"mangesh_yadav " wrote in message ...
Well, you have to use it like this

If Not IsNumber(TextHoursSpent.Value) Then
MsgBox "You must enter an integer. "
Exit Sub
End If

- Mangesh


---
Message posted from http://www.ExcelForum.com/