For Dummies 978-0-470-50369-0 Scheda Tecnica

Chapter 1What Is VBA?In This Chapter▶ Gaining a conceptual overview of VBA▶ Finding out what you can do with VBA▶ Discovering the advantages and disad

22Part I: Introducing VBA This book is written for Excel 2007 and Excel 2010, so if you don’t have one of those versions, you run the risk of gettin

14Part I: Introducing VBA What Can You Do with VBA?You’re probably aware that people use Excel for thousands of different tasks. Here are just a few e

15 Chapter 1: What Is VBA?In the following sections, I briefly describe some common uses for VBA macros. One or two of these may push your button.Inse

16Part I: Introducing VBA Creating a custom buttonYou can customize your Quick Access toolbar with your own buttons that execute the macros you write.

17 Chapter 1: What Is VBA?VBA advantagesYou can automate almost anything you do in Excel. To do so, you write instructions that Excel carries out. Aut

18Part I: Introducing VBA VBA in a NutshellJust to let you know what you’re in for, I’ve prepared a quick and dirty sum-mary of what VBA is all about.

19 Chapter 1: What Is VBA?objects. A Worksheet object can contain objects such as Range objects and PivotTable objects. The term object model refers t

20Part I: Introducing VBA ✓ You can assign values to variables. A variable is a named element that stores information. You can use variables in your

21 Chapter 1: What Is VBA? ✓ Excel 4: This version hit the streets in early 1992. It also uses the XLM macro language. A small number of people still