Microsoft Excel VBA Introduction

Overview and objectives of the Microsoft Excel VBA Training Course

This course will help students to take the first steps in application developement by using the features of Microsoft Excel 2003 and Visual Basic for Applications.

Target audience
Students should have familiarity with personal computers and the use of the keyboard and mouse. They should have completed introduction, intermediate and advanced courses in Excel 2003 or have equivalent practical experience

Course objectives

On course completion, students will be able to:

• Use Visual Basic for Applications terminology, start Visual Basic Editor, work with object properties, methods and events, execute code by using a button, and use the Object Browser

• Manipulate data by declaring variables and procedures of current scope to be used when and where you need them

Course contents
Getting Started
Introducing Visual Basic for Applications
Recording, running and editing a macro
Understanding the development environment
Understanding objects
Navigating the Excel object
Working with Statements, properties, events and methods

Working with Procedures and Functions
Understanding and Creating a standard module; sub procedures and functions procedures

Using Expressions, Variables and Functions
Understanding expressions and statements
Declaring variables, data types, scope of variables, Constants ,using spreadsheet functions.
Using message boxes
Using input boxes
Declaring and using object Variables