Introduction to Excel Visual Basic

Getting Started• Introduce Visual Basic for Applications• Record and Run a Macro• Absolute or Relative Cell Referencing• Save and Open Files with Macros• Edit a Macro in the Visual Basic Editor• Understand the Development Environment• Tips for General Typing in VBA• Use the Visual Basic Help• Assign Macros to Keyboard Shortcuts, Quick Access Toolbarand Buttons

Working with Procedures• Program Design• Understand and Create Modules• Understand Procedures• Program Macro Concepts• Create a Subroutine and a Function• Understand Arguments• Exit and Calling Procedures
Understand Objects, Properties, Methods and Events• Understand Objects Properties, Methods, Events• Navigate the Object Hierarchy• Understand Collections• Use the Object Browser• Use the With Statement• Work with Properties and Methods• Create an Event Procedure
Controlling Program Execution For Next• Understand Control-of-Flow Structures• Use the If...End If Decision Structures• Use the Select Case ...End Select Structure• Use the Do ...Loop Structure• Use the For ...Next Structure• Use the For Each ...Next Structure• Guidelines for Use of Control-of-Flow Structures
Using Expressions, Variables and Intrinsic Functions• Naming Rules• Understand Expressions and Statements• Declare Variables• Understand Data Types• Determine the Value of Variables• Work with Variable Scope• Use Built-in VBA Functions• Understand Constants• Use Built-in VBA Constants• Use Message Boxes• Control the Answer to a Message Box• Use Input Boxes• Declaring and Using Object Variables
Working with Forms and Controls• Understanding User Forms• Using the Toolbox• Working with a Form’s Properties, Methods, and Events• Working with Form and Control Properties, Methods and Event• Working with Form Controls• Setting the Tab Order• Populating a Control• Adding Code to Controls
Debugging and Handling Errors Error• Understanding Errors• Using Debugging Tools• Setting Breakpoints and Using Break Mode• Stepping Through Code• Trapping Errors with the On Error Statement• Understanding the Err Object• Working with Inline Error Handling• Writing an Error-Handling Routine