Excel VBA Introduction

Course review:

Macros

• Recording and Modifying Macros
• Assigning Macros to Toolbar, Buttons, Shortcut key

Visual Basic for Applications Environment

• Visual Basic Editor and its options
• Component Management
• Shortcuts
• Environment Optimization

Introduction to Procedural Programming

• Procedures: Functions and Sub-routines
• Data Types

Control Flow

• If ...Then....Elseif....Else....Endif
• Case
• Do...Loop , While
• For... Next
• Exit
• Arrays and Loops
• Strings

Visual Basic

• VBA and Sheet Data Exchange (Cells, Range Methods)
• Getting and Printing Data from Users (InputBox, MsgBox)
• Variable Declaration
• Scope and LifeTime of Variables and Objects
• Operators and Their Priorities
• Modules Options
• Creating Worksheet Functions
• Objects, Classes, Methods and Properties
• Locking Project for Viewing

Debugging

• Run Time, Design Time, and Break Mode
• Brakes and Watches
• Local Window
• Immediate Window
• Call Stack

Error Handling

• Errors Types
• On Error GoTo
• On Error Resume Next

Excel Model Object

• Application Object
• Workbook Object and Workbooks Collection
• Worksheet Object and Worksheets Collection
• ThisWorkbook, ActiveWorkbook, ActiveCell, ....
• Selection Object
• Range Collection
• Cells Collection
• Using Status Bar
• Screen Updating and Optimizing
• Timer and Time Measuring

Events Handling in VBA
VBA Forms

• Creating and Using Forms
• Invoking Forms in VBA Code
• Using VBA Forms in Worksheet