This course is included in the following Course Collections:
4 CoursesExcel Efficiency: Macros
- 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.
13 Reviews (42 ratings)Reviews
More please!Disagree Neutral Agree Strongly Agree Stated learning objectives were met Stated prerequisite requirements were appropriate and sufficient Program materials were relevant and contributed to the achievement of the learning objectives Time allotted to the learning activity was appropriate Instructor(s) was effective Course Overview CPE / CPD Quick Guide to Course Navigation Course Syllabus Progress: 93% INTRODUCTION AND OVERVIEW 6:36 Introduction; Handling Invalid Inputs Intro to Macros Part 4 7:27 Error Handling; Debugging Macros 6:08 Compile Errors; Syntax Errors 6:00 Text File Import Macro 7:37 MsgBox; GetOpenFileName 8:04 Opening the File; Optimizing Filtering 6:43 Simplifying Text To Columns; Macro Buttons; Halting Macros CONCLUSION 4:19 Additional Resources Continuous Play 52:54 Excel Efficiency : Intro to Macros Part 4 SUPPORTING MATERIALS PDF Slides: Intro to Macros Part 4 PDF Intro to Macros Part 4 Glossary/Index XLSX Intro to Macros Part 4-Excel 2007-2016 REVIEW & TEST quiz REVIEW QUESTIONS
Great course that helps walk through things that can cause macro to result in errors when running based on user input. Very helpful.
Very informative for those that want to expand Excel abilities. Presenter moves through material quickly but in depth.
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.
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.
Lots of good info on editing code behind macros.
Great intro and shown what is possible within Excel VBA
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.
instructor does a great job demonstrating complex topics.
Very helpful overview of how to use Visual Basic to customize/troubleshoot macros in Excel
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
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 .