Other VB Functions
Eval([expr]))
Evaluates an expression of VB code and returns the result
Example:
Function myFunc()
MsgBox("Hello world!")
End Function
Function otherFunc()
Eval("myFunc()") ' This will execute myFunc()
End Function
MsgBox("Hello world!")
End Function
Function otherFunc()
Eval("myFunc()") ' This will execute myFunc()
End Function
IsEmpty([expr])
IsNull([expr])
IsNumeric([expr])
IsObject([expr])
Returns a Boolean that perform variable type tests.
RGB(red, blue, green)
Returns a number that represents a RGB color. Each color is a number from 0 to 255.
VarType(expr)
Returns a number that represents the variable type. See table below.
| Value | Description |
|---|---|
| 0 | vbEmpty - Indicates Empty (uninitialized) |
| 1 | vbNull - Indicates Null (no valid data) |
| 2 | vbInteger - Indicates an integer |
| 3 | vbLong - Indicates a long integer |
| 4 | vbSingle - Indicates a single-precision floating point number |
| 5 | vbDouble - Indicates a double-precision floating point number |
| 6 | vbCurrency - Indicates a currency |
| 7 | vbDate - Indicates a date |
| 8 | vbString - Indicates a string |
| 9 | vbObject - Indicates an automation object |
| 10 | vbError - Indicates an error |
| 11 | vbBoolean - Indicates a boolean |
| 12 | vbVariant - Indicates a variant (used only with arrays of Variants) |
| 13 | vbDataObject - Indicates a data-access object |
| 17 | vbByte - Indicates a byte |
| 8192 | vbArray - Indicates an array |
Note: If the variable is an array VarType() returns 8192 + VarType(array_element). Example: for an array of integer VarType() will return 8192 + 2 = 8194.