(Advanced) Used to allow you to save a breakpoint in your Used with the Select keyword when using conditional Used with the Case keyword in conjunction with Used with the For keyword when repeating one or more Used with the For keyword to provide additional Used with the For keyword to access the individual Used with the While keyword when repeating one or more Used with the Do keyword when repeating one or more Used with the Until or Loop keywords when repeating one Used to exit a subroutine or function early before it (Advanced) Used with the GoSub keyword to return (Advanced) Used to trigger a class module user defined (Advanced) Used with the On Error keywords when using (Statement) Used to declare a user defined event. (Statement) Used to generate an error message. Used with the Error keyword when using error handling. Used with the If keyword in conjunction with conditional Used with the If keyword when using conditional Used with the Then keyword to allow conditional Used to terminate a subroutine, function or property. (Advanced) Used as an implicitly declared variable inside (Advanced) Used to reinitialize the elements in an array. (Advanced) Used to preserve the items in an array when it (Advanced, Function) Used to initialise or resize an (Advanced, Variables) Used to indicate that a variable Used when declaring one or more variables. Used to allow arguments to be passed in parentheses whenĮxecution moves inside a subroutine or function. (Advanced) Used when calling windows API functionality. (Advanced) Used when declaring an external procedure in aĭLL that has the same name and something else. (Advanced) Used to allow a dynamic number of arguments to Used to indicate that a variable passed to a subroutine Used to pass variables into subroutines and functions. Used to pass variables in and out of subroutines and (Data Type) Used to hold any type of data exceptįixed-length strings and user defined types. (Data Type) Used to contain a reference (or address) to (Data Type) Used to hold string variables that are fixed (Data Type) Used to hold numbers when you do not want any (Data Type) Used to hold double precision floating point (Data Type) Used to hold single precision floating point (Advanced, Data Type) Used to hold large whole numbers on (Data Type) Used to hold any whole number between Used to hold any whole number between -32,768 and 32,767. (Data Type) Used to hold either the value True or False. (Data Type) Used to hold any positive number between 0 Used when defining the data type of a variable or (Advanced) Used to perform multiple operations on a (Advanced) Used to define a user defined data structure. (Advanced) Used with the Class keyword when creating Used to define a user defined enumeration. (Advanced) Used with conditional compilation arguments. (Advanced) Used in class modules to prevent subroutinesįrom being accessed from external projects. Used to declare a subroutine that is visible from all the (Advanced) Used in class modules to define a variable Used to declare a block of code that does not return a Used to declare a block of code that can return a value. (Advanced) Used with the Property keyword when creating Used to declare a subroutine that is only visible in that Public variable that is visible from all the code modules. Used to change the string comparison settings, Option Used to force variables to be declared before they can be (Advanced) Used to change the string comparison settings, Used when changing the default lower bound of an array, If you want the table I’d created to automate the generation of the needed VBA code, you can grab from this pCloud file. I reordered and grouped the items by their function, so it has a comprehensible structure. This table was composed from the VBE object explorer, and broaden with more-info links of two sources, bettersolutions and excelfunctions blogs. Keywords are special words that are reserved, because they are used by the compiler to determine the structure of your code, so they cannot be used for variables, or subroutine or user defined function (UDF) names. Also, reserved words are displayed in color by default in the Code editor, but not VBA globals, which stay black color.
0 Comments
Leave a Reply. |