Microsoft Excel Macros Course

Topics covered on the 2 day Microsoft Excel Macros course

Part 1: Basics of writing VBA

Part 2: Selecting objects and setting values

• Overview
• Properties and methods
• Named vs Positional arguments
• Examples of Properties and Methods
• Exercise – selecting cells and inserting data

Part 3: Setting format properties

• Exercise – adding formatting to a worksheet

Part 4: Using variables to store information

• Data types for variables

Part 5: Interacting with the user

• Using an InputBox to get information
• Some examples of using the InputBox function
• Exercise 3 – Using InputBoxes to automate headers and footers

Code for Exercise 3

• Using a MsgBox
• Using a MsgBox to give information to the user
• Using a MsgBox to get information from the user
• Exercise 4 – Using MsgBox functions
• Exercise 5 – Using InputBoxes, MsgBoxes and functions

Part 6: Branching and looping

• The IF block
• Exercise 6 – Using IF…ELSE…END IF
• Select case
• Using SELECT CASE to test a single conditional against multiple outcomes
• Exercise 7 – Using Loops
• Exercise 8 – Using DO…LOOP

Part 7: Object Variables and FOR EACH… NEXT loops

• Exercise 9 – Using object variables
• Using the UNION function and multiple object variables
• Exercise 10 – Putting it all together