Overview
Recorded macros can't interact with the user. Macros that interact with the user are more user-friendly and flexible. Create pop-up dialogs to ask questions and use the response.
Why you should Attend
Recorded macros can't ask questions or tell you anything. See how to interact with the users.
When you write code you will make errors, everyone does,
See how to debug your code and remove the errors.
Areas Covered in the Session
- Learn the techniques that allow you to use one-way and two-way communication with the user whilst your macro is running
- Debugging involves removing errors from your code. As you build more complex macros you will need to improve your debugging skills
- Discover the built-in features in Excel that make this important process easier
Who Will Benefit
- Accountants and Finance Staff
Speaker Profile
Neale Blackwood is a Microsoft Excel expert with over 40 years’ experience as an Accountant and consultant. He has over 30 years’ experience using and writing about Excel. Neale has written over 250 Excel articles for the CPA Australia INTHEBLACK magazine since May 2002.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.
Instructor
Neale Blackwood