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