Introduction to VBA Programming

Introduction to VBA will acquaint new programmers with what VBA can do and with its programming environment. Basic skills and important concepts of VBA are taught.

    Sep 24 2021

    Date: 09/24/2021 - 09/24/2021 (Friday - Friday) | 9:00 AM - 4:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Introduction to VBA Programming

    September 24, 2021 | 9:00 AM - 4:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Nov 8 2021

    Date: 11/08/2021 - 11/08/2021 (Monday - Monday) | 9:00 AM - 4:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Introduction to VBA Programming

    November 8, 2021 | 9:00 AM - 4:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Jan 19 2022

    Date: 01/19/2022 - 01/19/2022 (Wednesday - Wednesday) | 9:00 AM - 4:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    Introduction to VBA Programming

    January 19, 2022 | 9:00 AM - 4:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

Get Started

  • What is VBA?
  • The Visual Basic Editor
  • Understand code
  • Get explanations
  • Use online references
  • Work with different applications
  • A little more code and some lists
  • Write code
  • Display a message box

Use Variables

  • Make a procedure accessible
  • Revise code
  • Create a form and its code

Forms

  • Start a new form
  • Add controls
  • Add the code
  • Test the code
  • Show the form

Conditions and Loops

  • Use conditions and loops 
  • For Each
  • Next and If Then
  • User interaction variations
  • Do While
  • Loop
  • Select Case

Arrays

  • Use an array and add to collections
  • Consider the possibilities
  • Set up the array
  • Declare the command bar and controls
  • Make them work together
  • Add a functionTest and clean up

Use a Calendar Control

  • Create a form and controls
  • Set control properties

CodeTest

  • Write the code
  • Test and refine
  • Deal with a modal form
  • Fix bugs and handle errors
  • Find the bug
  • Fix the bug
  • Test for errors
  • Write an error handler

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
  • Use variables
  • Forms
  • Conditions and Loops
  • Arrays
  • Use a calendar control
  • CodeTest

Prerequisites include intermediate to advanced training on Word and Excel or equivalent working knowledge of each software program.

This course is designed for students interested in learning general programming concepts. This course also provides a foundation for students desiring to learn one or more programming languages.

Ready to Jumpstart Your IT Career?

CONTACT US NOW!