Error

This keyword/value can only be used in conjunction with the Variant data type.
This keyword/value can be used to store an error number.
Normal error handling does not occur giving you the chance to take alternative action in code
Error values can be created by converting real numbers to error values using the CVErr() function
Error values are automatically generated by VBA when an error occurs.


Dim myVariant As Variant 
myVariant = Error
myVariant = Error(9)

CVError



IsError Function



varType.vbError




© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext