The correspondence of a pronoun with its antecedent in number (singular, plural), person (first, second, third), and gender (masculine, feminine, neuter).
Basic functions. 1  LBound(Array, Rank) â return the lowest subscript (index range) of the VBA Array within a certain dimension (Rank). 2  UBound(Array, Rank) â return the highest subscript (index range) of the VBA Array within a certain dimension (Rank). 3  ReDim â reallocate storage space for the array (set new array size).
VBA provides numerous built-in functions. Some of these functions take arguments and some do not. VBA function examples. Here are a few examples of using VBA functions in code. Note the use of the MsgBox function to display a value in a message box. Yes, MsgBox is a VBA function â a rather unusual one, but a function nonetheless. This useful function displays a message in a pop-up dialog box.