Learn Microsoft Excel 2000 VBA Programming
Julitta Korol · Wordware Publishing Inc. eBooks · 2000
From the Book: Whether you are using a spreadsheet to track your expenses or produce a series of monthly sales reports, you always find that you want something that's not included with the standard user interface. So how do you end up with what you really want? It's simple. Provide your own solution by learning how to program. In today's computer applications market, even the basic understanding of a common language, Visual Basic for Applications (VBA), can help you a great deal in eliminating limitations and inefficiencies that you encounter in getting your job done with the tools you already have. Having worked with Microsoft Excel for a while, you may come to realize that to work smarter you need to bring more automating power into your spreadsheets. But how do you go about this? Maybe someday there will be a built-in Procedure Wizard that takes down your spreadsheet recipe (figures, criteria, and decisions) in plain English and delivers a fully automatic and customized spreadsheet. But until then, the only sure way to bring automated power to Microsoft Excel is by taking a good look behind the Microsoft Excel Application window. Housed in a window separate from Excel is the Visual Basic Editor (VBE) with all the tools you'll need to produce flexible spreadsheets that can finally work the way you think they should. This book is intended to help you take charge of your Microsoft Excel spreadsheets by using VBA. In today's fast-paced world, you may not have much time to spend learning new skills. Quite often you are expected to produce tangible results before you even know how. Learn Microsoft Excel 2000 VBA Programming teaches you only the useful stuff. It limits your walking distanceby showing you things you must know to arrive quickly at your destination.