Learn Microsoft Excel 2000 VBA Programming

-

ISBN 10: 1556227035 / ISBN 13: 9781556227035

Published by - -, 2000

About this Item

This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping.

Seller Inventory # 6545-9781556227035

Bibliographic Details

• Title: Learn Microsoft Excel 2000 VBA Programming
• Publisher: - -
• Publication Date: 2000
• Language: English
• ISBN 10: 1556227035
• ISBN 13: 9781556227035
• Binding: Paperback
• Condition: Very Good

About this title

Synopsis

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.