Chapter 1. Using Macros and Form Controls
Introducing Excel Programming
As you probably know, Microsoft Excel is an electronic worksheet you can use for a variety of purposes, including the following: maintain lists; perform mathematical, financial, and statistical calculations; create charts; analyze your data with PivotTables; locate data; find trends in your data; and present your data to others.
This book is about automating the tasks you perform in Excel by using Visual Basic for Applications (VBA). You can use VBA to automate those repetitive tasks you perform frequently. For example, if the layout of your monthly report rarely changes, you can use VBA to set up your report each month.
VBA is a programming language; however, you do not have ...
Get Excel® Programming: Your visual blueprint™ for creating interactive spreadsheets now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
