The Visual Basic for Applications (VBA) programming language allows you to automate routine tasks in Excel—and it's not as hard to learn as most people think. In this course, Excel expert Curt Frye offers a crash course on VBA, sharing techniques that can help users of Excel 2007 or later get more out of this powerful program. Curt covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.
Topics include:
- Recall the limitations of a subroutine.
- List the steps taken to record a macro with a PivotTable.
- Identify the keyword used to resize an array.
- Explain what a VBA watch does.
- Name the Excel function that uses the distance from one cell to another.
- Determine how to delete a worksheet.
- Identify the type of variables that can be used in more than one subroutine.
- Summarize the effects of assigning a macro to a function key.