Course Content
Understanding the Concepts of Macros and VBA
- Explain the difference between a Macro and Visual Basic
- How to record a Macro
- Where your Macro is recorded
- Create a Macro using the Macro Recorder to consolidate data
- Look at the 7 different ways to run your macro including:
- Keyboard Shortcut
- Button on worksheet
- Quick Access Toolbar
Stepping Stones to Writing Efficient VBA Code
- Look at the significance of when to use an Absolute or Relative reference within a Macro.
- Analyse the difference in the VBA code and understand the syntax for both Absolute and Relative references.
- Understand the key elements of the Visual Basic Editor (VBE)
- Create a new Macro using the Code Window to include Dynamic Cell Selection (Special Cells)
- Identify and delete superfluous code in a recorded Macro
Visual Basic Essentials
- Colour guidelines and keyboard shortcuts
- What the Object Model is
- Excel Object Library containing code words
- Object properties
- Methods in VBA
- How to find the correct syntax (property or method)
- Rows, columns and range referencing
- Cells and offset referencing
- How to reference worksheets and workbooks
- Useful built-in functions
Debugging
- Methods to debug code
- How and when to use the Immediate Window