Overview
Learn Microsoft Excel 2000 VBA Programming leads you through the process of creating VBA procedures from start to finish with detailed, practical "how-to" examples and plenty of illustrations. You'll learn how to:Take advantage of the built-in macro recorder to speed up repetitive spreadsheet tasks and learn essential VBA commands and statements. Control many features of Microsoft Excel with objects, properties, and methods.
Write subroutines and functions from scratch. Add decision-making to your procedures with If.Then, If.Then.Else, and other statements.
Use looping structures to repeat statement sequences in your code. Manage lists and tables of data with arrays. Manipulate files and folders programmatically using VBA statements and functions.
Control other applications from Excel through DDE and Automation. Create and customize user forms by following the sample applications. Modify the user interface by creating your own menus and toolbars. Learn how to handle errors and debug your programs by using watch expressions and breakpoints.
The companion CD contains all VBA procedures and supplementary files used in the book's exercises.
Learn Microsoft Excel 2000 VBA Programming teaches you how to get the most from the world's most popular spreadsheet by utilizing its powerful built-in tool-the Visual Basic for Applications (VBA) programming language. If you've already mastered the fundamentals of Excel, it's time to move forward and learn Excel's secret weapon. With VBA you can delegate many tedious tasks to Excel and execute them later with just the press of a button. You can produce fully automatic and flexible spreadsheet solutions for yourself or others.