WE OFFER FLEXIBLE SCHEDULING, SO PLEASE REQUEST AN ALTERNATE CLASS DATE OR TIMEFRAME IF NEEDED!
Course Description
The student will learn not only how to capitalize on the macro recording capability within Excel, but also how to understand the VBA code that generates behind-the-scenes in order to then start building your own VBA statements. Common VBA programming code structures such as functions, decision control structures, loops, interactive message and input boxes, debugging and error handling are all a part of this one-day course.
Prerequisite
Excel Advanced and/or equivalent experience
Software Version
Microsoft (Office) 365, 2021, 2019, 2016
Course Highlights
Macro recording
Choices for running macros
Understanding VBA code
Visual Basic Editor
Editing VBA Code
Constants and Variable Declarations
Defining a Function
Decision Code Structures
Loop Structures
Interactive Messages
Debugging
Error handling
Save this product for later
Request our latest computer tip
Computer Tip Request
Stay tuned for a helpful computer tip coming to your email soon! Thank you for contacting Computer Sense!
Oops, there was an error submitting your request. Please try again later.
You will find the highest quality software instruction, technology consulting and coaching with us.