Introduction to Excel Macros (Currently Unavailable)

In Part 2 of Introduction to Excel Macros, Excel expert David Ringstrom, CPA, takes you beyond the basics of using Excel’s Record Macro feature and explains how to enhance the code you’ve created by adding error-handling features and decision-making capabilities. David shares techniques and keyboard shortcuts that will help you eliminate repetitive tasks and become more proficient with Excel macros.

Part 3 of this series on Excel macros expands your ability to write programming code. Excel expert David Ringstrom shows you how to create a macro that can reset workbooks that have skewed scrollbars, along with a second macro that can be used to instantly unhide all worksheets in a workbook at once. David goes deeper into making decisions in programming code by contrasting If and Select Case statements. He also contrasts three ways of creating loops in Excel: For Each, Do While, and Do Until. In addition, David explains how to troubleshoot problematic loops in Excel, which in certain instances can cause Excel to crash.

Part 4 of this series on Excel macros introduces the concept of UserForms in Excel. Excel expert David Ringstrom walks you through creating custom dialog boxes that can add interactivity in Excel and can better manage a user’s actions. David first walks you through the most common controls used within UserForms. He then builds a custom printing interface that he dubbed “Plug and Print,” which allow users to pick and choose the worksheets to print from any workbook. The presentation also shows how to create a basic UserForm for prompting users to input data, including making all fields required. Finally, you’ll see how to move module sheets and UserForms between workbooks, as well as how to remove them from workbooks when no longer needed.

If you want to learn how to create and implement macros—one of Excel’s most powerful features—this presentation is designed just for you. Excel expert David Ringstrom, CPA, introduces you to the concept of Excel macros as well as to the Visual Basic for Applications (VBA) macro. He also explains how to use the Record Macro feature and Excel’s Personal Macro Workbook. After participating in this course, you’ll be prepared to begin utilizing macros immediately.