Course description
Visual Basic Techniques and Strategies
Find practical ways to automate tasks and build a better workflow.
Visual Basic® for Applications (VBA) is an event-driven programming language for Microsoft® Office Applications. It has powered Microsoft Excel®’s macros since the mid-1990s. 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.
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
Who should attend?
This live webinar is designed for
- business owners and managers
- supervisors
- associates
- analysts
- bookkeepers and accountants.
Training content
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
Certification / Credits
Learning Objectives
- You will be able to describe how to design and implement objects and events.
- You will be able to identify how to set up looping with Do loops and Do While loops.
- You will be able to discuss the integration of macros and VBA.
- You will be able to explain how to develop efficient procedures with correct syntax.
Contact this provider
Lorman Education Services - Live and On-Demand Courses
Lorman Education Services is a leading provider of online professional development and corporate training for organizations and individual professionals. For more than 30 years, Lorman has delivered relevant, high-quality, professional-level courses that cover a broad range of business and technical...