Visual Basic For Applications Training in Denver & Phoenix

technicalWant 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.

Class Price: $750

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.

PreRequisites

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

Loops

  • 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 ContentControls
  • Getting the ContentControl’s Numerical Value
  • Arrays
  • Calculating the Average Value
  • Writing the Results to the Results Form

    Events

  • Word Events
  • Excel Events
  • Using Events to Automatically Enter Data
  • In and Out Cells
  • Other Events

 

Upcoming Classes

VBA
Nov 27 - Nov 28 8:00 am - 4:00 pm VBA Tech Center VBA Visual Basic For Applications Training in Denver & Phoenix Want to know how to write macros? Want to know how to make Microsoft applications do more than the standard ribbon... Mission Critical Systems 27-11-2018T08:00 27-11-2018T16:00 Active
Active 27-11-2018 Active 750.00 27-11-2018
Register Now
VBA
Nov 29 - Nov 30 8:00 am - 4:00 pm VBA Phoenix VBA Visual Basic For Applications Training in Denver & Phoenix Want to know how to write macros? Want to know how to make Microsoft applications do more than the standard ribbon... Mission Critical Systems 29-11-2018T08:00 29-11-2018T16:00 Active
Active 29-11-2018 Active 750.00 29-11-2018
Register Now
VBA
Feb 4 - Feb 5 8:00 am - 4:00 pm VBA Westminster VBA Visual Basic For Applications Training in Denver & Phoenix Want to know how to write macros? Want to know how to make Microsoft applications do more than the standard ribbon... Mission Critical Systems 04-02-2019T08:00 04-02-2019T16:00 Active
Active 04-02-2019 Active 810.00 04-02-2019
Register Now
VBA
Apr 15 - Apr 16 8:00 am - 4:00 pm VBA Phoenix VBA Visual Basic For Applications Training in Denver & Phoenix Want to know how to write macros? Want to know how to make Microsoft applications do more than the standard ribbon... Mission Critical Systems 15-04-2019T08:00 15-04-2019T16:00 Active
Active 15-04-2019 Active 810.00 15-04-2019
Register Now
VBA
Jun 12 - Jun 13 8:00 am - 4:00 pm VBA Tech Center VBA Visual Basic For Applications Training in Denver & Phoenix Want to know how to write macros? Want to know how to make Microsoft applications do more than the standard ribbon... Mission Critical Systems 12-06-2019T08:00 12-06-2019T16:00 Active
Active 12-06-2019 Active 810.00 12-06-2019
Register Now
VBA
Sep 19 - Sep 20 8:00 am - 4:00 pm VBA Phoenix VBA Visual Basic For Applications Training in Denver & Phoenix Want to know how to write macros? Want to know how to make Microsoft applications do more than the standard ribbon... Mission Critical Systems 19-09-2019T08:00 19-09-2019T16:00 Active
Active 19-09-2019 Active 810.00 19-09-2019
Register Now
VBA
Oct 1 - Oct 2 8:00 am - 4:00 pm VBA Westminster VBA Visual Basic For Applications Training in Denver & Phoenix Want to know how to write macros? Want to know how to make Microsoft applications do more than the standard ribbon... Mission Critical Systems 01-10-2019T08:00 01-10-2019T16:00 Active
Active 01-10-2019 Active 810.00 01-10-2019
Register Now