Discover Classes. Earn Rewards.
Visual Basic for Applications is unfortunately unavailable

Thankfully we have 1 other Visual Basic Class for you to choose from. Check our top choice below or see all classes for more options.

Visual Basic for Applications

at Mission Critical Training - Westminster

Course Details
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

8601 Turnpike Dr Ste 105
At Sheridan Blvd
Westminster, Colorado 80031
Purchase Options
Class Level: All levels
Age Requirements: 16 and older
Average Class Size: 18

What you'll learn in this visual basic training:

Want to know how to write macros? Want to know how to make Microsoft applications do more than the standard ribbon commands? Learn how to write your own commands and code in the Visual Basic For Applications Technical Training in Denver & Phoenix.

Training Class Goal
VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft. VBA is the tool that allows you to develop programs that control Microsoft Office applications. This is a beginning VBA course that will familiarize the student with the VBA programming environment. It will provide the foundation for exploring and programming the objects, methods, properties and events of Office applications.

Proficiency in Microsoft Office applications, specifically Word, Excel and PowerPoint.

VBA Topics Covered

Enabling the Visual Basic Editor
  • The Developer Tab
  • The VBA Toolbar
  • Macro Security
The Visual Basic Editor
  • The Code Window
  • The Project Pane
  • Sharing Macros
  • The Immediate Window
  • The Debug Toolbar
  • The Locals Pane
  • The Watch Pane
  • Getting Help with VBA
Objects, Properties, Methods
  • Object Properties
  • Object Methods
  • Object Events
  • Collections
  • With…End With
  • Recording vs Writing Macros
  • The Object Browser
Visual Basic as a Programming Language
  • Coding
  • Variables
  • Data Types
  • Literal Values
  • Declaring Variables
  • Constants
  • Scope
  • Operations
  • MsgBox and InputBox
  • Branching
  • The If Statement and Construct
  • Select Case
  • The For Loop
  • The Do Loop
  • Nested Loops
  • The Recorded Macro Example
  • Looping through Files in a Folder
  • Setting the Working Folder
  • Opening Each Form in Word
  • Looping Through the Content
  • Controls
  • Getting the Content
  • Control’s Numerical Value
  • Arrays
  • Calculating the Average Value
  • Writing the Results to the Results Form
  • Word Events
  • Excel Events
  • Using Events to Automatically Enter Data
  • In and Out Cells
  • Other Events

Still have questions? Ask the community.


Google Map

Mission Critical Training

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 8100 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Mission Critical Training (1)

School: Mission Critical Training

Mission Critical Training

Mission Critical Training offers training and development services including classes in Microsoft Office products, Adobe, and professional development. Services include public training centers, on-site private training, e-learning development and Instructional Design. Our focus is high quality training...

Read more about Mission Critical Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified DEN educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

1 Top Choice

Intermediate Excel: Formulas & Functions

at General Assembly - Northern Denver 3858 Walnut St, Denver, Colorado 80205

The Intermediate Excel: Formula and Functions workshop is designed for students who have mastered the material from the Excel at Excel workshop and are looking to build upon those skills.  Given that there lacks an enforceable prerequisite, the workshop does review a few topics from the Excel at Excel workshop, including conditional math functions...

Tuesday Dec 3rd, 6pm - 9pm