Microsoft Excel Macros & VBA Beginner Level 3
-
Getting Started
-
Variables and Constants
- Specifying a data type
- Specifying integral numeric data types
- Scientific notation – Part 1
- Scientific notation – Part 2
- Scientific Notation – Part 3
- Specifying non-integral numeric data types – Introduction
- Specifying non-integral numeric data types – Single
- Specifying non-integral numeric data types – Double
- Specifying non-integral numeric data types – Currency
- Floating point vs fixed point – Part 1
- Floating point vs fixed point – Part 2
- Floating point vs fixed point – Part 3
- Specifying non-numeric data types – String
- Specifying non-numeric data types – Boolean
- Specifying non-numeric data types – Date – Part 1
- Specifying non-numeric data types – Date – Part 2
- Specifying non-numeric data types – Date – Part 3
- Specifying non-numeric data types – Object – Part 1
- Specifying non-numeric data types – Object – Part 2
- Specifying non-numeric data types – Variant
- Review of data types
- Scope – Introduction
- Scope – Procedure level
- Scope – Module level
- Scope – Project level
- Scope – Global level
- Review of scope
- Declaring multiple variables with one statement
- Explicit vs implicit declarations – Part 1
- Explicit vs implicit declarations – Part 2
- Explicit vs implicit declarations – Part 3
- Explicit vs implicit declarations – Part 4
- Using the locals window
- Variables are initialized at run – Part 1
- Variables are initialized at run – Part 2
- Assigning data types to constants
- Declaring scope for constants
- Organizing variables and constants
- Predefined constants
- Enumerations
- Viewing information about a predefined constant
- Values that constants cannot be initalized to
- Practice assignment Part 1
- Practice assignment Part 2
- Practice assignment Part 3
- Practice assignment Part 4
-
Functions
- Introduction
- VBA function syntax
- Using VBA functions
- A function is a type of procedure
- Accessing help on VBA functions
- Qualifying a CBA function
- Using worksheet functions
- Qualifying worksheet functions
- MsgBox function – Syntax and arguments
- MsgBox function – Displaying a message only
- MsgBox function – Assigning the returned value to a variable
- MsgBox function – Coding tip!
