• Introduction to Excel
• Introduction to Programming
• VBA Overview and the IDE
• Quick Review of Macros Working with Macros
• How to use Visual Basic Editor (Programming Environment)

• An easy-to-use and versatile language
• Integrated with off-the-shelf products

• The Visual Basic Editor
• Parts of the VBA Editor
• Modules and Macros
• About VBA Forms, Sub Procedures & Modules
• Creating Forms
• Using Controls and their Properties
• Running VBA Forms in Excel

• Objects – The Grammar
• Using Properties and Methods
• Understanding Parameters
• The Object Browser
• Understanding object hierarchy
• Tools for better coding
• Moving to Other Cells
• Editing Specific Cells

• How and when to declare variables
• Selecting data types
• Fixed and dynamic arrays
• Constants

• IF (Else If, Else) Select Case ()
• For Next Loop
• For Each Loop ()
• Do Until Loop and Do While Loop With, EndWith
• Nesting Code

• Creating Sub and Function procedures
• Calling procedures
• Passing arguments to procedures

• Communicating with the user through the message box
• Gathering user information with the input box
• Utilizing the File Dialog object and Dialogs collections

• Using the Immediate Window
• Gaining greater control through the immediate window
• Formatting Cells
• Using Variables
• Constants
• Object Variables
• Dimensioning and usage of variables
• Displaying data and obtaining data from the user

• Command buttons
• List and Combo boxes
• Labels
• Option buttons
• Check boxes
• Text boxes
• Frames
• Adding more functionality with advanced ActiveX control

• Using Font Property in cells
• Using Various Background Properties in Excel VBA
• Creating a Counter
• String Handling
• Using Left, Right, Mid and Len Functions in VBA
• Range Selection and Manipulation

• Workbook and Worksheet Object
• Range Object and Cell Properties
• Methods and Properties
• Assigning Objects
• Using Name Arguments

• What is Array& why use array
• Declaring an Array
• Sorting Data in Array
• 2-Dimention Array
• Dynamic Array
• UBourd
• Storing Data in a range of an Array Elements
• Using various array functions

• Using Excel Worksheet Functions in VBA
• VBA Functions
• User-Defined Functions
• Adding Help to User Defined Functions
• Declaring Variables in User Defined Functions
• Using Ranges in User Defined Functions
• Creating and Managing an Add-in for User Defined Functions

• Run Time Error
• GoTo line
• GoTo0
• GoTo 1
• Resume Next

• Copy Hyperlinks and Text from a webpage to Spreadsheet

• Communicating with Word and PowerPoint using Excel VBA