• Author:
  • Walkenbach, John
• Subject:
  Business Applications
• Published by:
  John Wiley & Sons Inc (US)
• Published:
  19/06/1997
• Price:
  $37.99
• <  Buy this book  >

By itself, Excel 97 can do some pretty amazing stuff. Add Visual Basic for Applications (VBA) and you add a whole other dimension of automation and customization. Excel 97 Programming For Windows For Dummies offers plenty of practical examples of Excel programming in action and explains in plain English how to
* Save time and improve accuracy by automating common tasks
* Design custom dialog boxes to suit your and your organization's needs
* Build specialized functions to use in your worksheets
* Create add-ins, take advantage of the Windows API, and define custom data types
With numerous books and articles on Excel to his credit, John Walkenbach is the ideal author to make Excel programming understandable, whether you're new to programming or just new to this latest release of Excel.

John Walkenbach has written hundreds of articles and numerous books, including Microsoft?? Excel 2000 Formulas. He is the principal of JWalk Associates, a spreadsheet application development company.

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.