View Single Post
  #2  
Old 20-02-2011, 08:35
runflacruiser's Avatar
runflacruiser runflacruiser is offline
Senior Member
 
Join Date: Jun 2009
Location: Pigeon Forge, TN USA
Posts: 811
Default

Hi.
Like this:

Code:
Sub testIt()
    Dim n
    n = 5
    'n = "Something else"
    If Not IsNumeric(n) Then Exit Sub
    MsgBox "N is a number!"
End Sub
-John
Reply With Quote