Introducing VBA
- Introduction
- Excel Overview
- Recording a Macro
- Reviewing Macro Code
- Overview Of VBA And Office
- Objects, Methods And Properties
- Differences Between Office 2003, 2007, 2010 And 2013
- Creating A Macro Enabled Workbook
Macro Recorder Part 1
- Introduction
- Recording A Macro To Format Cells
- Recording A Macro To Format Cells As Currency
- Recording A Macro To Swap Two Columns
- Recording A Macro Using Relative References Rather Than Absolute
- Recording A Macro To Turn Gridlines On And Off
- Tweaking Macros To Change Their Functionality
Macro Recorder Part 2 - a larger example
- Introduction
- Some Useful Functionality In Excel For Cell Selection
- Importing A Text File
- Filling Blank Cells With Data
- Adding A Column With The Date
- Creating A Pivot
- Creating A Chart
- Deleting Sheets And Charts
- Putting Them All Together
Forms
- Introduction
- Creating A Simple Switchboard Form To Call Our Previous Macros
- Adding A Button To The Ribbon To Display The Form
- Using The Auto Open Events To Display The Form
- The Name List Form, Dealing With Events
- Using String Functions To Manipulate Text
- Creating A Form To Interact With Data On A Sheet
Loops
- Introduction
- Looping Through Data In A Column With The For Loop
- The While Loop
- Using ‘Cells’ To Access A Cell
- Looping Through Variable Length Lists
- Looping Through Data In A Column With Spaces
- Calling Formula To Determine When To Stop A Loop
- Creating Reusable VBA Code
- Finding And Formatting Data Using Loops
User Defined Functions
- Introductions
- Creating A User Defined Function (UDF)
- Creating A Variable Discount Calculation UDF
- Error Handling In VBA
- Debugging In VBA
Automation
- Introduction
- Automating Word From Excel
- Automating Powerpoint From Excel
- Automating Outlook From Excel
- Getting Data From Access Into Excel Using VBA
Security
- Introduction
- Personal Macro Workbook
- Macro Security Levels
- Using A Digital Signature
VBA Language review
- VBA Language review
