Microsoft Excel 2000 Power Programming with VBA

From the Book: Welcome to Microsoft Excel 2000 Power Programming with VBA. If your job involves developing spreadsheets that others will use-or if you simply want to get the most out of Excel-you've come to the right place. By reading this book, you can expand your spreadsheet horizons and get even more power from Excel. Experience tells me that many spreadsheet users spend much of their time creating spreadsheets that other people use. Increasingly, spreadsheets designed with products such as Excel, 1-2-3, and Quattro Pro are suitable for tasks that once required custom programs written in traditional programming languages. Thanks to their macro and customization features, these products now can serve as development platforms for many types of applications. In this book, I cover every aspect of application development using Excel. Why I wrote this Book Over the past 15 years, I've written scores of spreadsheet reviews for the leading trade magazines. During this time, I've seen spreadsheets evolve from simple accounting worksheets to incredibly powerful applications. Microsoft Excel goes well beyond what most people consider the realm of spreadsheet software. I am particularly impressed with Excel's capabilities in the area of application development, especially development using the Visual Basic for Applications (VBA) macro language. Quite a few advanced Excel books are available, but this book is still the only that deals with application development from a larger perspective. VBA is just one component (albeit a fairly large component) of application development. Excel is an extremely deep software product: It has many interesting features that lurk in the background,unbeknownst to the typical user. And you can use some of the well-known features in novel ways. Millions of people throughout the world use Excel. I monitor spreadsheet-related newsgroups on the Internet, and it's very clear to me that people need (and want) help in the areas that this book covers. My guess is that only five percent of Excel users really understand what the product is capable of. In this book, I attempt to nudge you into that elite company. Are you up to it?