The key topics that it covers include recorded macros, the macro editor, using and defining variables, creating custom forms and working with the various objects within Microsoft Excel.
INTRODUCTION TO EXCEL VBA
- Creating a Macro
- Running the Macro
- Examining the code behind the macro
INTRODUCING THE VISUAL BASIC EDITOR (VBE)
- Opening the Visual Basic Editor
- Recognizing Parts of the Visual Basic Editor
- Menus – View, Insert, Format, Debug, Run & Tools Menu
EXPLORING VISUAL BASIC FOR APPLICATIONS
- Objects and Collections
- Workbook and Worksheet Object
- Range Object and Cells Property
- Methods and Property
- Assigning Object Variables and Using Named Argument
DECLARING VARIABLES, CONSTANTS AND DATA TYPES
- Declaring Variables
- Defining Data Types
- Defining Constants
- Assigning Values to Variables
- Handling Strings
- Handling Dates and Times
- Handling Variants and Data Type Conversions
MODULES AND PROCEDURES
- Modules and Procedures and Their Scope
- Calling Sub Procedures and Function Procedures
- Understanding Variable Scope and Lifetimes
- Exercises
WRITING YOUR FIRST VBA FUNCTION IN EXCEL
- About User-Defined Functions
- A Function to Calculate the Area of a Rectangle
- A Function to Calculate Fuel Consumption
- Accessing Your Custom Functions
DECISION STRUCTURES
- IF … Then Statement
- IF … Then … Else
- Exercise: A Function to Calculate the Area of a Rectangle – (IF)
- Select Case
- Exercise: A Function That Gives the Name of the Day
LOOP STRUCTURES
- For … Next
- For … Next Loop With Step
- Do While … Loop
- Do Until … Loop
- Do … Loop While
- Exercises 0..8
COMPLEX EXERCISES
- Adding Up the Coloured Numbers