Tags content that has to do with statements used to declare program identifiers in VBA.
VBA programs are nothing but a sequence of VBA statements. They are the cornerstone of VBA programs. Here, we explore these vital elements of VBA coding.
![Declaring Enumerations - the Enum statement’s syntax. Square brackets, [ ], indicate optional items while vertical bars, |, indicate mutually exclusive items.](https://masterofficevba.com/wp-content/uploads/2021/03/Enum_Statement_Syntaxnew.png)
The Enum statement declares VBA enumerations or Enums. Enums are widely used in VBA programs, so it’s useful exploring their declaration, as you’ll do here.
The Const statement declares constants in VBA. Constants are prevalent in VBA programs, so it is useful to explore their declaration, as you’ll do here.
![Declaring Variables - the Dim statement’s syntax. Square brackets, [ ], indicate optional items while vertical bars, |, indicate mutually exclusive items.](https://masterofficevba.com/wp-content/uploads/2021/03/Dim_Statement_Syntaxnew.png)
The Dim statement declares VBA variables and objects. It is ubiquitous in most VBA programs, so it is worthwhile exploring it in-depth as you’ll do here.
![Declaring Function Procedures - the Function statement’s syntax. Square brackets, [ ], indicate optional items while vertical bars, |, indicate mutually exclusive items.](https://masterofficevba.com/wp-content/uploads/2021/03/Function_Statement_Syntaxnew.png)
The Function statement declares VBA functions. All executable VBA code is in such procedures, so this post’s detailing of the Function statement is vital.
![Declaring Sub Procedures - the Sub statement’s syntax. Square brackets, [ ], indicate optional items while vertical bars, |, indicate mutually exclusive items.](https://masterofficevba.com/wp-content/uploads/2021/03/Sub_Statement_Syntaxnew1.png)
The Sub statement declares VBA subroutines. All executable VBA code is in such procedures, so, exploring the Sub statement, as you’ll do here, is vital.