EXCEL MACROS WITH VBA
Day 1 of the VBA for Excel Course
Pre-requisits: A very good working knowledge of Microsoft Excel
Day 1: Excel Macros with
VBA
Introduction to Microsoft Excel Macros and VBA
The Microsoft Excel Macro Recorder
Recording a Macro
A Practical Example
Playing a Macro
Absolute and Relative Recording
Deciding between Relative VS Absolute Referencing
Making Your Macros Accessible
Adding Buttons to your Worksheet
Adding Controls from the Forms Toolbar
Adding Controls from the Control Toolbox Toolbar
Custom Toolbars
A Peak into the world of VBA Programming
The Visual Basic Editor
Code Procedures and Modules
The Project Explorer
The Properties Window
Updating a Recorded Macro
Creating User Defined Functions
Programming Microsoft Excel with VBA and more
UDF's
Direct Reference to Ranges
What UDFs cannot do and some other tips
The Microsoft Excel Object Model
Microsoft Excel Objects
Microsoft Excel Collections
Microsoft Excel VBA Object Properties
Microsoft Excel VBA Object Methods
The Microsoft Excel VBA Object Browser
Experimenting in the Immediate Window