Definitive Guide to Excel VBA
In this book, Michael Kofler provides definitive coverage of Visual Basic for Applications (VBA) for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it also covers advanced topics needed for users al...
Main Author: | |
---|---|
Format: | eBook |
Language: | English |
Published: |
Berkeley, CA
Apress
2000, 2000
|
Edition: | 1st ed. 2000 |
Subjects: | |
Online Access: | |
Collection: | Springer Book Archives -2004 - Collection details see MPG.ReNa |
Table of Contents:
- I An Intuitive Approach
- 1 Writing Your First Macro
- 2 What’s New in Excel 2000
- II Foundation
- 3 The Development Environment
- 4 VBA Concepts
- 5 Techniques of Programming
- 6 Debugging, Protection When Errors Arise
- 7 Forms (Microsoft Forms Library)
- 8 Menus and Toolbars
- III Application
- 9 Templates, Smart Forms
- 10 Charts and Drawing Objects (Shapes)
- 11 Data Management in Excel
- 12 Access to External Data
- 13 Data Analysis in Excel
- 14 VBA Programming for Pros, Office Developer
- IV Reference
- 15 Object Reference