Excel Macro Programming: Advanced Techniques for Error-Handling and Decision-Making
Welcome to Exceptional Excel - Intro to Macros Part 2!
Building upon the foundations laid in Part 1 using the Macro Recorder, this course takes you deeper into automating your workflows by venturing into the Visual Basic Editor (VBE).
In this part, you will learn to write and modify macro code directly, adding powerful decision-making capabilities to handle different scenarios gracefully. We explore how to interact with users through Input Boxes to solicit data and use Message Boxes to provide essential feedback and confirmations. Mastering error handling techniques will empower you to anticipate and manage runtime issues, preventing macros from crashing and ensuring a smoother user experience.
You'll also gain proficiency in essential debugging practices, enabling you to troubleshoot and refine your code efficiently. Furthermore, discover how to write code that prompts users to select specific files and integrate this functionality into your macros.
By the end of this course, you will be equipped to transform your recorded macros into more robust, interactive, and intelligent automation tools, including creating user-friendly buttons on your spreadsheets for easy access. Elevate your Excel automation skills by truly understanding and writing VBA code.
Lambers, Inc. is a leader in review courses for the EA, AFSP, and CPA exams. Lambers also offers IRS Continuing Education for Tax Preparers and CPE for CPAs. Accounting and finance professionals around the world incorporate Lambers products into their training programs.
CPA
David H. Ringstrom, CPA, is President of Accounting Advisors, Inc., a spreadsheet and database consulting firm. He is a Certified Public Accountant, a technical editor for the For Dummies book series, and the author or co-author of five books, including previous editions of QuickBooks
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
