IsNumeric()
This function returns true if the selected item is Numberic (Numbers) and false if it is not.
Use -
VB Code:
IsNumeric([Expression]) as boolean
[Expression] Would be the item you were looking to see if it was numeric.
Example -
VB Code:
If IsNumeric("78906") = True Then MsgBox ("True") End If 'The above statement would return the true msgbox If IsNumeric("5566pp578") = True Then MsgBox ("true") End If ' This statement would not because the string we specified contains characters "pp"
So this function returns true if a specified expresion is numerical and flase if it is not
Note - It does also work for decimals so 0.8950 would return true





Reply With Quote