logo
ABD
LiveZilla Live Chat Software



Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey
While System Source is working from home, we are still available for all of your calls and support needs.

Advanced Visual Basic for Applications (VBA)

SS Course: 3000354

Course Overview

TOP

You will learn to use flow control, create custom dialogs, automate processes, and handle errors. Each lesson begins with a general overview of a feature and then shows how that feature works in each of the Office applications.

                                                                  

Scheduled Classes

TOP

What You'll Learn

TOP
  • Learn to use the Select Case statement and the MsgBox function.
  • Learn to work with the repetition structure.
  • Learn to work with built-in dialog boxes.
  • Learn to create custom dialog boxes.
  • Learn to work with option button, check box, and list box controls.
  • Learn to use Automation.
  • Learn to trap errors.

Outline

TOP
Viewing outline for:

1. Using the Select Case Statement and the MsgBox Function

    • Understanding Select Case Statement and MsgBox Function
    • Using the Select Case Statement and the MsgBox Function in Excel
    • Using the Select Case Statement and the MsgBox Function in Word
    • Using the Select Case Statement and the Msgbox Function in Access

2. Working with the Repetition Structure and the With Statement

    • Understanding the Repetition Structure and the With Statement
    • Using the Repetition Structure and the With Statement in Excel
    • Using the Repetition Structure and the With Statement in Word
    • Using the Repetition Structure and the With Statement in Access

3. Advanced Repetition Structure and String Functions

    • Using the String Repetition Structure and String Functions
    • Using the String Repetition Structure and String Functions in Excel
    • Using the String Repetition Structure and string Functions in Word
    • Using the String Repetition Structure and String Functions in Access

4. Working with Custom Dialog Boxes

    • Creating Custom Dialog Boxes
    • Using Custom Dialog Boxes in Excel
    • Using the Custom Dialog Boxes in Word
    • Using the Custom Dialog Boxes in Access

5. Working with Option Button, Check Box, and List Box Controls

    • Discussing the Dialog Box Controls
    • Using the Option Button, Check Box, and List Box Controls in Excel
    • Using the Option Button, Check Box, and List Box Controls in Word
    • Using the Option Button, Check Box, and List Box Controls in Access

 6. Automation

    • Understanding the Automation Process
    • Using Automation in Excel
    • Using Automation in Word
    • Using Automation in Access

7. Advanced Automation and Error Trapping

    • Discussing Automation and Error Trapping
    • Using Automation and Error Trapping in Excel
    • Using Automation and Error Trapping in Word
    • Using Automation and Error Trapping in Access

Prerequisites

TOP

Experience in the following is required for this VBA class:

  • Expertise in Microsoft Word, Excel and Access
  • Basic VBA Skills as taught in Introduction to Visual Basic for Applications (VBA)

    Who Should Attend

    TOP

    Next Step Courses

    TOP