Instructor for this course
Duration: 1 Hour
Level: Advanced
Access This Course: Instant Access to Course Library

In this course Excel expert David Ringstrom, CPA, starts out by adding more error-handling capabilities to the Goal Seek macro he started in Part 3. The discussion then shifts to enhancing the accounting report clean-up macro introduced in Part 2 of the series. David shows how to build in yes/no prompts, allow the user to choose a specific file to process, and enhance code generated by Excel's Macro Recorder to create flexible macros that can deal with data sets of varying sizes. You also learn debugging techniques that are useful in resolving errors within both macros that you record or that you enhance with additional programming code.

David teaches from Excel 2010 but provides handouts with numbered steps that are specific to Excel 2003, Excel 2007, Excel 2010, Excel 2013, and 2016.

Topics covered:

  • Add error handling features to Excel macros to compensate for unexpected or missing data entry inputs.
  • By-pass the filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.
  • Learn the nuances of Macro-Enabled workbooks in Excel 2007 and later.
  • Learn what to do next if a Debug prompt appears.
  • See how to use Excel's Macro Recorder to create simple macros without any programming knowledge required.
  • Use the Text to Columns feature to eliminate unwanted text without retyping, or to separate text into separate columns.

This course is part of a series of courses:

Excel Efficiency : Intro to Macros Part 1
Excel Efficiency : Intro to Macros Part 2
Excel Efficiency : Intro to Macros Part 3
Excel Efficiency : Intro to Macros Part 4 (This Course)

Learning Objectives

  • Identify how to enhance user feedback in message boxes with icons
  • Identify the keyboard shortcut that allows you to step through programming code one line at a time.
  • Identify keyboard shortcuts for halting a running macro.

11 Reviews (41 ratings)Reviews

Anonymous Author
Great course that helps walk through things that can cause macro to result in errors when running based on user input. Very helpful.
Anonymous Author
Very informative for those that want to expand Excel abilities. Presenter moves through material quickly but in depth.
Anonymous Author
Good course. Worth having to expand your understanding of the range of applications macros can have especially to round out the previous 3 macro courses.
Member's Profile
Thanks for opening the world of VBA. I have done some basic macro work - but when anything gets big turn to Visual FoxPro (my lifelong tool of choice). VFP has been deprecated - so this course has given me a nudge to do more within Excel when the opportunity presents itself.
Member's Profile
Lots of good info on editing code behind macros.
Anonymous Author
Very good.
Member's Profile
Great intro and shown what is possible within Excel VBA
Member's Profile
This course best illustrates how complex the macro coding process is and the fact that you're not going to learn it in a couple of 1 hr sessions - so temper expectations. There is a host of underlying code knowledge required to move from the simple macro recorder to highly functioning complex macros. I appreciate that the author acknowledged such and provided references for those that wish to pursue the next level.
Anonymous Author
instructor does a great job demonstrating complex topics.
Anonymous Author
Very helpful overview of how to use Visual Basic to customize/troubleshoot macros in Excel
Anonymous Author
Learned a lot but was probably the most difficult of the 4 part series. There was a lot more discussion versus seeing excel in action. I'm sure this was due to the complexity.


No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.

Education Provider Information

Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 ext. 106, or send an e-mail to .
Course Syllabus
Intro to Macros Part 4
  7:27Error Handling; Debugging Macros
  6:08Compile Errors; Syntax Errors
  6:00Text File Import Macro
  7:37 MsgBox; GetOpenFileName
  8:04Opening the File; Optimizing Filtering
  6:43Simplifying Text To Columns; Macro Buttons; Halting Macros
  4:19 Additional Resources
Continuous Play
  52:54Excel Efficiency : Intro to Macros Part 4
  PDFSlides: Intro to Macros Part 4
  PDFIntro to Macros Part 4 Glossary/Index
  XLSXIntro to Macros Part 4-Excel 2007-2016