Anyone who wishes to harness the power that Excel can demonstrate when combined with programming inVisual Basic.

Getting Started

• Introducing Visual Basic for Applications
• Displaying the Developer Tab on the Ribbon
• Recording a Macro Saving a Macro-Enabled
• Workbook
• Running a Macro
• Editing a Macro in the Visual Basic Editor
• Understanding the Development Environment
• Using Visual Basic Help
• Closing the Visual Basic Editor
• Understanding Macro Security

Understanding Objects

• Understanding Objects
• Navigating the Excel Object Hierarchy
• Understanding Collections
• Using the Object Browser
• Working with Properties
• Using the With Statement
• Working with Methods
• Creating an Event Procedure

Working with Procedures and Function

• Understanding Modules
• Creating a Standard Module
•  Understanding Procedures
• Creating a Sub Procedures
• Calling Procedures
• Using the Immediate Window to Call Procedures
•  Creating a Factor Procedures
• Naming Procedures
•  Working within Code Editor

Using Expressions, Variables, and Intrinsic Functions

• Understanding Expressions and Statement
• Declaring Variables
• Understanding Data Types
• Working with Variable Scope
• Using Intrinsic Functions
• Understanding Constants
• Using Intrinsic Constants
• Using Message Boxes
• Using Input Boxes
• Declaring and Using Object Variables

Controlling Program Execution

• Understanding Control-of-Flow Structures
• Working with Boolean Expressions Using the If…End If Decision Structures Using the Select Case…End Select Structure Using the Do…Loop Structure
• Using the For…To…Next Structure
• Using the For Each… Next Structure
• Guidelines for use of Control-of-Flow
• Structure

Working with Forms Control

• Understanding User Forms
• Using the Toolbox
• Working with User Form Properties, Event,
• and Methods
• Understanding Controls
• Setting Control Properties in the Window
• Working with the Label Control
• Working with the Text Box Control
• Working with the Command Button Control
• Working with the Combo Box Control
• Working with the Frame Control
• Working with Option Button Control
• Working with Control Appearance
• Setting the Tab Order
• Populating a Control

Working with the PivotTable Object

• Understanding PivotTables
• Creating a PivotTables Using Worksheet
• Data
• Working with PivotTables Object Working with the PivotTables Collection Assigning s Macro to the Quick Access
• Toolbar
• Debugging Code
• Understanding Errors
• Using Debugging Tools
• Setting Breakpoint
• Stepping through Code
• Using Break Mode During Run mode
• Determining the Value of Expressions

Handling errors

• Understanding Error Handling
• Understanding VBA’s Error Trapping Options
• Trapping Errors with the On Error Statement
• Understanding the Err Object
• Writing an Error-Hardling Routine
• Working with Inline Error Handling