This course is designed to give proficiency to create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.

Prerequisites: A strong knowledge in all Microsoft Office Applications, especially Excel.

Visual Basic Editor

·         Visual Basic for Applications

·         Object Programming

·         The Object Browser

Programming basics

·         Data

·         Scope of Variables

·         Scope of Procedures

Control Structures

·         Decision Structures

·         Loop Structures

Custom Dialog Boxes

·         User Forms

·         Events

Debugging and Error Handling

·         Errors

·         Debugging

·         Error-handling

Objectives

·         Use the Visual Basic for Applications (VBA) terminology and start Visual Basic Editor (VBE), work with object properties and methods and attach code to events and buttons, and use the Object Browser to get information about objects.

·         Use the variables of relevant data types, manipulate data by using expressions, get input from the user, declare and use variables of correct scope, declare and use procedures of correct scope, create Sub and Function procedures, and call one procedure from another.

·         Use decision structures to create procedures that execute code based on specific conditions and use loop structures to execute specific code repeatedly.

·         Add a user form to your project and add controls to the user form and validate the data entry in the controls.