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.
About the Author
Julitta Korol is a computer consultant, technical writer, and software trainer. She is a best-selling author of nine computer books published by Mikom Publishing in Warsaw, Poland, and the author of the forthcoming Learn Word 2000 VBA by Example (1-55622-748-5) from Wordware. She lives in Long Island, N.Y.
