Summary : Excel 97 Programming for Windows for Dummies |
|
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.
Excerpts from Inner Flap (Front) |
|
Tips and tricks for writing powerful macros with VBA! Your first aid kit ® for designing user-friendly applications Find out how to create custom dialog boxes, toolbars, menus, and more! If you want to write programs that perform time-consuming procedures in a snap, then this is the book for you! Inside you’ll find explanations on how Visual Basic for Applications works with Excel, how-to guidance on Visual Basic Editor, and tried-and-true tips to help you write and run some really cool macros. Discover how to: Make your VBA code run with speed Enhance spreadsheet functionality Create custom add-ins Modify an objects properties Debug your applications Add online help features to worksheets The Dummies Way Explanations in plain English “Get in, get out” information Icons and other navigational aids Tear-out cheat sheet Top ten lists A dash of humor and fun Get smart! Register to win cool prizes Browse exclusive articles and excerpts Get a free Dummies Daily e-mail newsletter Chat with authors and preview other books Talk to us, ask questions, get answers.