Excel Essentials: Introduction to Macros Part II
In this session Excel expert David H. Ringstrom, CPA helps you go beyond the Macro Recorder introduced in Part I. You'll see how to create Visual Basic routines that make decisions, as well as how to create loops that repeat the same task a specified number of times. You'll also see how to create user forms in Excel, which allow you to create custom input screens.
Finally, you'll get advice on ironing out problems in your programming code. David will focus primarily on Excel 2007 and later, but will answer questions specific to earlier versions. Alternate instructions for Excel 2003 and earlier are included in the handout where applicable.
Expand your existing knowledge of Visual Basic for Applications
- Use Select Case, If, and For statements in Visual Basic to create code that can make decisions on the fly
- Transfer macros between workbooks
- Create customizable prompts that gather information from a user or inform them that the macro is complete.
- Learn how to create the Plug and Print tool that David shares in the Introduction to Macros class
- Build user forms that collect data from users to be posted elsewhere in a spreadsheet
- Learn debugging techniques such as breakpoints and compiling your code
- Get recommendations on additional resources to expand your knowledge of automating tasks in Excel
A basic understanding of Excel.
No advance preparation required
Level of Knowledge
Group internet Based
NASBA Field of Study