City of St. Catharines Learning & Development

To take this course you must already know how to record macros and / or have already take Excel Course 7 Introduction to Macros.

Take a deeper dive into Excel's VBA Editor and learn how to bring your macros to life. This course helps you go beyond basic recordings by teaching you how to modify existing macros and write custom code using VBA—so you can automate tasks and boost your productivity.

Writing Macros

• Macros You Can't Record
• Macros Triggered by Events
• Macro Arguments
• Sub vs Function
• Module, Sheet or Workbook

Commands/Features

• Variables
• With, End With
• Message Boxes
• IF, Else, Endif
• For, Next
• The Range Object
• Intersect
• Exit a Procedure
• Display and Calculation