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).
Syntax of MsgBox function in VBA: The syntax of VBA Msgbox is as follows: MsgBox (Text_String [, buttons] [, title] [, helpfile, context]) Here âText_Stringâ is the message that you want the msgbox to display. The maximum length of âText_Stringâ is 1024 characters. âbuttonsâ parameter specifies the type of buttons and icon that you want to be shown on the message box.