Introduction to Microsoft Visual Basic

Course content

Introduction

• Aims and objectives of delegates
• What is a macro?

Recording a Macro

• Recording and storing macro code
• Replaying macros
• Absolute / Relative references

Working with the Visual Basic Editor

• Using the Visual Basic Editor
• Understanding objects, properties and methods
• Editing code
• Writing code

Working with Variables

• Understanding variables
• Passing variables between macros
• Using arrays

Looping Structures

• For Next
• For Each
• Do While / Until
• Select Case

Displaying Messages

• Message boxes
• Input boxes

Debugging Macros

• Error trapping
• Using the immediate window
• Using breakpoints

Event Management

• On Open / Close
• Selection Change
• On Click
• Select Worksheet

Working with the Forms

• Using forms and controls
• Using option groups and check boxes
• Reading data from worksheets
• Returning items from a form
• Cancelling a form

Prices will vary depending on your requirements and the number of delegates participating in the training. We can offer scheduled courses and on or off site training specifically for your company at a fixed daily rate.