Excel VBA macros (online)

• Absolute and relative recording
• Where macros can be stored
• Assigning macros to buttons

• Selecting cells (absolute)
• Selecting cells (relative)
• Selecting to the end of a block
• Selecting a range by its corners

• Using Project Explorer
• Creating modules
• Basic subroutines and comments

• Input boxes and message boxes
• Declaring variables
• Option Explicit
• Scope of variables
• Constants

• The Excel object model
• Objects and collections
• Methods and properties
• Getting help in VBA

• Simple IF conditions
• Multiple IF and SELECT / CASE
• Three main types of loop

• Object variables
• Looping over collections

• Assigning macros to events
• Cancelling events

• Declaring functions
• Passing arguments

• Setting breakpoints
• Stepping through macros
• ON ERROR statements

• Drawing forms
• Attaching macros to controls
• Validating form input

If time

• Links to Word or Access
• Working with files and folders