Excel Macros and VBA

Introduction and the Macro Recorder
Introduction 
Demonstration 
Recording a macro 
Recording a macro with absolute references 
The personal macro workbook 
Assigning shortcut keys 
Deleting macros
Excel’s New File Format 
Recording a macro with relative references 
Exercises

Creating and Editing Macros With VBA Macro Functions
Macro storage concepts 
The VBA program (the VB editor) 
The program components  
Storing and handling macros (modules) 
Introduction to editing code 
Copying and pasting procedures 
Linking procedures together 
Create and use a user-defined function 
Auto-executable macros 
Exercises  

Objects and Dialog Boxes
Introduction to objects 
The object browser 
Using the object browser and searching it 
Built-in dialog boxes 
User defined dialog boxes (message boxes and input boxes) 
Exercises

Introduction to Controls
Worksheet controls 
User forms
Assign Macros to the Ribbon or Quick Access Toolbar
Accessing Macros in Excel 
Exercises