Excel Essentials: Introduction to Macros Part II


Overview
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.
 
Objectives
Expand your existing knowledge of Visual Basic for Applications
 
Emphasis

  • 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
Prerequisite
A basic understanding of Excel.
 
Preparation
No advance preparation required
 
Level of Knowledge
Basic/intermediate
 
CPE Credit
2 Hours
 
Delivery Method  
Group internet Based
 
NASBA Field of Study
Computer Science