VBA IsNumeric Function
In this Article
IsNumeric Description
Used to check for a numeric value.
Simple IsNumeric Examples
|
1 |
MsgBox IsNumeric("123") |
Result: True
|
1 |
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
|
1 |
MsgBox IsNumeric("Number") |
Result: False
|
1 |
MsgBox IsNumeric("12.34") |
Result: True
|
1 |
MsgBox IsNumeric("12:00") |
Result: False
To check the cells on Excel Sheet, you can use the following example.
|
1 2 3 4 5 6 7 |
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!
Learn More!
