Excel 2010/13/16 Macros

Prerequisite: Has attended the Excel Intermediate course or has equivalent knowledge.

Duration: One day

Course Topics

Recorded macros
* The Visual basic toolbar
* Absolute macros
* Relative macros
* Personal macro Workbook
*Types of macros

The Visual basic module
* Overview of the components
*Visual Basic Editor
* The structure of a macro
* Basic visual basic commands
* Editing a macro
* Adding Comments

Making macros easier to use
* Adding Buttons to toolbars and menus
* Adding comm and buttons to your worksheet
*InputBox and MsgBox functions

Debugging a macro
* Stepping through your code
* Breakpoints
* The intermediate window
* Watches

Overview of Visual basic syntax
* Objects, properties, methods
* Useful visual basic code

Conditions
* IF / THEN / ELSEIF / ELSE constructs
* Case Statement

Loops
* Do / Until, Do / While loops
* For / Next Loops
While / Wend

Function macros
*Difference between Procedure and Function macros
*Writing Function macros

Automated macros
* Auto open and auto close macros
* XL start directory
* Workbook and worksheet events