Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Handheld Computing
Hardware
Money Management Software
Multimedia
Office Productivity Software
Operating Systems
Moms, Dads, and Grads -- Win $500!
Excel 97 Programming for Windows For Dummies

Excel 97 Programming for Windows For Dummies


By John Walkenbach

ISBN: 978-0-7645-0132-6
Format: Paper
Pages: 405 Pages
Pub. Date: July 1997

E-mail a Friend About This Book
Price: $24.99
Description
Author Information
Table of Contents
Introduction.

PART I: Introducing VBA.

Chapter 1: What Is VBA?

Chapter 2: Jumping Right In.

PART II: How VBA Works with Excel.

Chapter 3: Introducing the Visual Basic Editor.

Chapter 4: Introducing the Excel Object Model.

Chapter 5: VBA Subroutines and Functions.

Chapter 6: Using the Excel Macro Recorder.

PART III: Programming Concepts.

Chapter 7: Essential VBA Language Elements.

Chapter 8: Working with Range Objects.

Chapter 9: Using VBA Functions and Excel Functions.

Chapter 10: Controlling Program Flow and Making Decisions.

Chapter 11: Automatic Procedures and Events.

Chapter 12: Error-Handling Techniques.

Chapter 13: Bug Extermination Techniques.

Chapter 14: VBA Programming Examples.

PART IV: Developing Custom Dialog Boxes.

Chapter 15: Custom Dialog Box Alternatives.

Chapter 16: Custom Dialog Box Basics.

Chapter 17: Using Dialog Box Controls.

Chapter 18: Dialog Box Techniques and Tricks.

PART V: Creating Custom Toolbars and Menus.

Chapter 19: Customizing the Excel Toolbars.

Chapter 20: When Excel's Normal Menus Aren't Good Enough.

PART VI: Putting It All Together.

Chapter 21: Creating Worksheet Functions — and Living to Tell about It.

Chapter 22: Creating Excel Add-Ins.

Chapter 23: Creating Excel Applications for Other Users.

PART VII: The Part of Tens.

Chapter 24: Top Ten VBA Tips and Tricks.

Chapter 25: Top Ten VBA Questions (And Answers).

Chapter 26: Top Ten Excel Resources.

Index.

Related Articles
Reorganizing an Excel Worksheet
Building an Array Formula in Excel
Working with Trendlines in an Excel Chart
Putting Excel Data in Order with Sorting Keys
Setting Task Duration in Microsoft Project 2007
Related Titles
Microsoft Office 97 For Windows For Dummies
Microsoft Office 2000 9 in 1 For Dummies Desk Reference
Microsoft Office 2000 For Windows For Dummies
Microsoft Office 2000 for Windows For Dummies: Quick Reference
Excel For Dummies, 2nd Edition