Check Format
Thank you very much this works!
"Susan" wrote:
you could use the Not IsNumeric concept..........
If Not IsNumeric(TempZIP) Then
MsgBox "Invalid Zip code, Please Try again "
End If
if this doesn't work exactly, try searching
the newsgroup for "Not IsNumeric" for help
with this.
susan
|