Description
Find practical ways to automate tasks and build a better workflow.Visual Basic for Applications (VBA) is an eventdriven programming language for Microsoft Office Applications. It has powered Microsoft Excel’s macros since the mid1990s. VBA was built to work with and extend the abilities of Office applications.Learn the various programming nuances of VBA and gain proficiency in creating procedures that run in response to specific events while developing forms to accept, validate, and display data along with debugging and error handling.
Date: 2021-05-07 Start Time: End Time:
Learning Objectives
Review of the VBA Environment
• When and Why to Use VBA
• Review of the VBA Screen
• Shortcuts
Objects
• The Object Browser
• Excel Objects and Hierarchy
• Macros and VBA
• Controls and Inputs
Procedures
• Variables and Expressions
• Arguments and Parameters
• Declaring Variables
• Functions
• Using an InputBox
• Creating an Excel Function
• Automating Excel
• Operators
• Arithmetic Operators
• Comparison Operators
• Logical Operators
• Concatenation Operators
Program Execution
• If
End If
• Do
Loop
• For
Next
Debugging Code
• Break Mode
• Immediate Window
• Watch Window
• iLocals Window
• Error Handling
• On Error
Forms and Controls
• The Toolbox
• Designing Forms Using Controls
AIPB ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.
Lauritta Sowa-WiseOwlOps, Inc.