Microsoft Visual Basic for Applications (VBA) in Microsoft Excel

Course Overview

This training course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling.

Audience

Those who require the fundamental skills to create useful and powerful VB applications.

Skills Gained

• After the course delegates will be able to:
• Work with Command and Function procedures
• Understand Variables
• Work with Objects
• Create User Forms
• Set options within Excel
• Observe event handling codes
• Debug Code

Examinations

A list or description of examinations which will, or can be, taken following completion this course.

Prerequisites

A good working knowledge of Excel will maximise the benefits derived from this course.

Course Outline

• Introduction to the VBA environment
• Command & Function procedures
• Using Variables
• Operators
• Objects
• Collections
• Properties
• Methods
• Design Making Code If...then
• If...then...else
• Select case
• Code that repeat's
• Do...loop
• For...next
• Using exit in Loops
• Using VBA to display information
• Reading and setting Excel's options Application objects
• Worksheet objects
• Range objects
• Using Forms
• Controls
• Event handling code
• User defined menus & toolbars
• Add in Applications
• Breakpoints and watches
• The Immediate Window

Microsoft Visual Basic for Applications (VBA) in Microsoft Excel / MVBExc