Recorded Macros

• Understanding Excel Macros
• Add Developer Tab
• Setting Macro Security
• Saving A Document As Macro Enabled
• Recording A Simple Macros
• Running A Recorded Macro
• Relative Cell References
• Editing A Macro
• Assigning A Keyboard Shortcut To A Macro
• Deleting A Macro
• Copying A Macro
• Form controls & ActiveX

Recorder Workshop

• Create a Data Base
• Advance Filter
• Testing Macros
• Assigning A Macro To An object

Understanding VBA

• VBA Terminology
• About objects
• Accessing The Excel object Model
• Using The Immediate Window
• Working With object Collections
• Setting Property Values
• Working With Worksheets
• Using The object Browser

The VBA Editor

• Opening and closing the editor
• Working with the project explorer
• Working with the properties window
• Working with the work area
• Working with a code module
• Setting breakpoints in the editor
• Stepping through a procedure

Programming Techniques

• The Mgs Function
• Sending Messages To The User
• Input Techniques
• Using The Input Function
• The If Statement
• Using If form Single Conditions
• Using If form Multiple Conditions
• Select Case 
• For Next
• The Do...Loop Statement
• For Each

Using Excel objects

• Application Methods And Properties
• Workbook Methods And Properties
• Using Workbook objects
• Worksheets Methods And Properties
• Using Worksheet objects
• Range Methods And Properties
• Using Range objects
• Using objects In A Procedure

Procedures

• Creating A Command Procedure
• Using The Edit Toolbar
• Commenting Statements
• Indenting Code

Using Variables

• Understanding Variables
• Creating And Using Variables
• Implicit And Explicit Declarations
• The Scope of Variables
• Data Types
• Declaring Data Types
• Using Arrays
• Error Handling
• Error Types
• On Error
• Creating A Simple Error Handler
• Using The Resume Statement
• Using The Err object
• Error Handling In Event Procedures

User Defined Functions

• About Functions
• Creating Simple User-Defined Functions
• Using User-Defined Functions
• Using Multiple Arguments

Creating Custom Forms

• About Custom Forms
• Creating A Custom Form
• Adding Text Boxes T A Form
• Changing Text Box Control Properties
• Adding Label Controls T A Form
• Adding A Combo Box Control
• Adding option Buttons
• Adding Command Buttons
• Running A Custom Form

Programming User Forms

• Handling Form Events
• Closing A Form
• Running Form Procedures
• Running Form Procedure

Automatic Startup & Excel Events

• Programming Automatic Procedures
• Running Automatic Procedures
• Automatically Starting A Workbook