Excel VBA Training: Excel 2010 VBA Training

Excel 2010 VBA Training Outline

• Overview
• Recorded Macros
• Understanding Excel Macros
• Setting Macro Security
• Saving a Document as Macro Enabled
• Recording a Simple Macro
• Running a Recorded Macro
• Relative Cell References
• Running Macro with Relative References
• Viewing a Macro
• Editing a Macro
• Assigning a Macro to the Toolbar
• Running a Macro from the Toolbar
• Assigning a Keyboard Shortcut to a Macro
• Deleting a Macro
• Copying a Macro
• Recorder Workshop
• Preparing Data for an Application
• Recording a Summation Macro
• Recording Consolidations
• Recording Divisional Macros
• Testing Macros
• Creating Objects to Run Macros
• Assigning a Macro to an Object
• Understanding VBA
• Programming in Microsoft Excel
• VBA Terminology
• Understanding Objects
• Viewing the Excel 2010 Object Model
• Using the Immediate Window
• Working with Object Collections
• Setting Property Values
• Working with Worksheets
• Using the Object Browser
• Programming with the Object Browser
• The Best VBA Help Available
• The VBA Editor
• The VBA Editor Screen
• Opening and Closing the Editor
• Using the Project Explorer
• Working with the Properties Window
• Using the Work Area
• Viewing Other Panes
• Working with Toolbars
• Working with a Code Module
• Running code from the Editor
• Setting Breakpoints in the Editor
• Stepping Through Code
• Procedures
• Understanding Procedures
• Where Procedures Live
• Creating a New Sub Routine
• Making Sense of IntelliSense
• Using the Edit Toolbar
• Commenting statements
• Indenting Code
• Bookmarking in Procedures
• Using Variables
• Understanding Variables
• Creating and Using Variables
• Implicit and Explicit Declarations
• The Scope of Variables
• Procedure Level Scoping
• Module Level Scoping
• Passing Variables by Reference
• Passing Variables by Value
• Data Types
• Declaring Data types
• Using Arrays
• Functions In VBA
• Understanding Functions
• Creating VBA Functions
• Using a VBA Function in a Worksheet
• Setting Function Data Types
• Using Multiple Arguments
• Modifying a VBA Function
• Creating a Function Library
• Referencing a Function Library
• Importing a VBA Module
• Using a Function In VBA Code
• Using Excel Objects
• The Application Object
• The Workbook Objects
• Program Testing with The Editor
• Using Workbook Objects
• The Worksheets Object
• Using the Worksheets Object
• The Range Object
• Using Range Objects
• Using Objects in a Procedure
• Programming Techniques
• The MsgBox Function
• Using MsgBox
• InputBox Techniques
• Using the InputBox Function
• Using the InputBox Method
• The IF Statement
• Using IF for Single Conditions
• Using IF for multiple Conditions
• The Select Case Statement
• Using The Select Case Statement
• For Loops
• Looping With specified Iterations
• The Do...Loop Statement
• Looping With Unknown Iterations
• Creating Custom Forms
• About Custom Forms
• Creating a Custom Form
• Adding Text Boxes to a Form
• Changing Text Box Control Properties
• Adding Label Controls to a Form
• Adding a Combo Box Control
• Adding Option Buttons
• Adding Command Buttons
• Running a Custom Form
• Programming UserForms
• Handling Form Events
• Initializing a Form
• Closing a Form
• Transferring Data From a Form
• Running Form Procedures
• Creating Error Checking Procedures
• Running a Form From a Procedure
• Running a Form from the Toolbar
• Automatic Startup
• Programming Automatic Procedures
• Running Automatic Procedures
• Automatically Starting a Workbook
• Error Handling
• Error types
• The On Error statement
• Creating a Simple Error Handler
• Using the Resume Statement
• Using Decision Structures in Error Handlers
• Using the Err object
• Error Handling in Event Procedures
• Defining Custom Errors
• Conclusion