VBA Programming

Description

This course will introduce students who are familiar with Word, Excel or Access the basics of writing and debugging VBA code. VBA is Microsoft's Visual Basic for Application and is the tool used to create custom macros and user-interfaces in the Office applications. Students will learn to define variables, create loops and branching statements, define functions, get user input and interface with the application of their choice. Students will need a copy of Microsoft Word, Excel or Access. A 30-day trial is available.

Objectives

• Students will record macros and use the VBA editor to view and edit them.
• Students will use the VBA to create macros.
• Students will write VBA code which uses arrays.
• Students will write VBA code to work with objects, methods and properties.
• Students will write VBA code to define and use functions.
• Student will write VBA code which uses use decision and loops statements.
• Students will write VBA code which uses message boxes and input boxes.
• Students will design and use dialog boxes in their VBA applications.
• Students will write code to handle errors and use the debugging tools to find errors in their code.
• Students will create a final project to show what they have learned in this course.

Book

Lesson 1: Getting Started

Read Chapters 1, 2 and 3.

If you will be working with one or two applications in Office, focus more on the parts related to what you will be working with.

Lesson 2: Creating Macros Using the VBA Editor

Read Chapters 4, 5 and 6.

Chapter 4: Only do the example related to the application(s) you are interested in.
Chapter 5: Don't panic if you don't understand it all. This is mainly to introduce vocabulary.
Chapter 6: This will be the most important part of this lesson.

Lesson 3: Arrays

Read Chapter 7

Pay particular attention to page 117-123 (2003 book) or 135 - 142 (2007 book).
The rest of the chapter uses content we have not really covered. If you are familiar with programming then take a look at it. If not, wait until we cover a little more content and come back to it.

Lesson 4: Working with Objects

Read Chapter 8.

(Also review Chapters 20-29 for the applications you will be using.)

Lesson 5: Functions

Read Chapters 9 and 10.

Lesson 6: Decisions and Loops

Read Chapters 11 and 12.

Lesson 7: Message Boxes

Read Chapter 13

Lesson 8: Custom Dialog Boxes

Read Chapter 14.
If you want to know more, read Chapter 15.

Lesson 9: Debugging and Error Handling

Read Chapter 17

Lesson 10: Putting it All Together

Review the chapters we have covered.

All content of this document is copyrighted by IDEA Solutions and the author. All rights reserved. Content may not be used without permission.