Return to VBA Code Examples

VBA IsNumeric Function

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on July 19, 2021

IsNumeric Description

Used to check for a numeric value.

Simple IsNumeric Examples

MsgBox IsNumeric("123")

Result: True

MsgBox IsNumeric("123ABC")

Result: False

IsNumeric Syntax

In the VBA Editor, you can type  “IsNumeric(” to see the syntax for the IsNumeric Function:

The IsNull function contains an argument:

Expression: An expression that will be evaluated.

Examples of Excel VBA IsNumeric Function

MsgBox IsNumeric("Number")

Result: False

MsgBox IsNumeric("12.34")

Result: True

MsgBox IsNumeric("12:00")

Result: False

To check the cells on Excel Sheet, you can use the following example.

Sub IsNumeric_Example()
    Dim cell As Range
    
    For Each cell In Range("A2:A7")
        cell.Offset(0, 1) = IsNumeric(cell.Text)
    Next cell
End Sub

 

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users! vba save as


Learn More!
vba-free-addin

VBA Code Examples Add-in

Easily access all of the code examples found on our site.

Simply navigate to the menu, click, and the code will be inserted directly into your module. .xlam add-in.

(No installation required!)

Free Download

Return to VBA Code Examples