VBA Information Function

VBA Information Functions

VBA Information Functions:

VBA Information Functions can be use to convert numeric values or strings. These are ENVIRON, IsArray, IsDate, IsEmpty, IsError, IsMissing, IsNull, IsNumeric, IsObject etc. These functions are Built-In functions. We can use these VBA Information functions in either procedure or function. These functions we use in the VBA editor window in Excel. These Information functions you can use any number of times in VBA macro codes.

List of Information Functions in Excel VBA:

Here are the list of Information functions. And also find its description, syntax and return type. We can use these multiple Information functions in one statement.

Function Description Syntax Return Type
VBA ENVIRON VBA ENVIRON function returns value of the current operating system environment variable. Environ(Expression) String
VBA IsArray VBA IsArray function checks a specified variable is an array or not. IsArray(VarName) Boolean
VBA IsDate VBA IsDate function checks specified Expression is date or not. It returns True if it is valid date. IsDate(Expression) Boolean
VBA IsEmpty VBA IsEmpty function checks specified Expression is empty or not. IsEmpty(Expression) Boolean
VBA IsError VBA IsError function checks specified Expression is error or not. IsError(Expression) Boolean
VBA IsMissing VBA IsMissing function checks specified an optional argument is missing or not. IsMissing(ArgName) Boolean
VBA IsNull VBA IsNull function checks specified Expression is Null or not. IsNull(Expression) Boolean
VBA IsNumeric VBA IsNumeric function checks specified Expression is Numeric or not. IsNumeric(Expression) Boolean
VBA IsObject VBA IsObject function checks specified variable is an object or not. IsObject(Expression) Boolean

List of VBA Functions:

Please click on below link to go back to see all List of VBA Functions.

Quick View of VBA Information Functions List of VBA Functions

Leave a Comment

Your email address will not be published. Required fields are marked *