Objective

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 using VBA.

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

Outline

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


Credits

1.40 Continuing Education Units
Course ID #TECH163



Class Details

Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:02/04/2019-02/05/2019
Time:8:00 am to 4:00 pm
List Price:$730.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:06/12/2019-06/13/2019
Time:8:00 am to 4:00 pm
List Price:$730.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:10/01/2019-10/02/2019
Time:8:00 am to 4:00 pm
List Price:$730.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:04/15/2019-04/16/2019
Time:8:00 am to 4:00 pm
List Price:$730.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:09/19/2019-09/20/2019
Time:8:00 am to 4:00 pm
List Price:$730.00

Don't see what you are looking for?

Contact Us