Excel 2002 Power Programming with VBA
Rights Contact Login For More Details
- Wiley
More About This Title Excel 2002 Power Programming with VBA
English
John Walkenbach is a principal of JWalk and Associates, Inc., a consulting firm that specializes in spreadsheet application development, and is the author of more than two dozen books, including, most recently, Excel 2002 Bible and Excel 2002 Formulas. He maintains "The Spreadsheet Page," a popular Web resource at www.j-walk.com/ss.
English
Preface.
Acknowledgments.
PART I: Some Essential Background.
Chapter 1: Excel 2002: Where It Came From.
Chapter 2: Excel in a Nutshell.
Chapter 3: Formula Tricks and Techniques.
Chapter 4: Understanding Excel's Files.
PART II: Excel Application Development.
Chapter 5: What is a Spreadsheet Application?
Chapter 6: Essentials of Spreadsheet Application Development.
PART III: Understanding Visual Basic for Applications.
Chapter 7: Introducing Visual Basic for Applications.
Chapter 8: VBA Programming Fundamentals.
Chapter 9: Working with VBA Sub Procedures.
Chapter 10: Creating Function Procedures.
Chapter 11: VBA Programming Examples and Techniques.
PART IV: Working with UserForms.
Chapter 12: Custom Dialog Box Alternatives.
Chapter 13: Introducing UserForms.
Chapter 14: UserForm Examples.
Chapter 15: Advanced UserForm Techniques.
PART V: Advanced Programming Techniques.
Chapter 16: Developing Excel Utilities with VBA.
Chapter 17: Working with Pivot Tables.
Chapter 18: Working with Charts.
Chapter 19: Understanding Excel's Events.
Chapter 20: Interacting with Other Applications.
Chapter 21: Creating and Using Add-Ins.
PART VI: Developing Applications.
Chapter 22: Creating Custom Toolbars.
Chapter 23: Creating Custom Menus.
Chapter 24: Providing Help for Your Applications.
Chapter 25: Developing User-Oriented Applications.
PART VII: Other Topics.
Chapter 26: Compatibility Issues.
Chapter 27: Manipulating Files with VBA.
Chapter 28: Manipulating Visual Basic Components.
Chapter 29: Understanding Class Modules.
Chapter 30: Frequently Asked Questions about Excel Programming.
Appendix A: Excel Resources Online.
Appendix B: VBA Statements and Functions Reference.
Appendix C: VBA Error Codes.
Appendix D: ANSI Code Reference.
Appendix E: What's on the CD-ROM.
Index.
End-User License Agreement.
CD-ROM Installation Instructions.
Acknowledgments.
PART I: Some Essential Background.
Chapter 1: Excel 2002: Where It Came From.
Chapter 2: Excel in a Nutshell.
Chapter 3: Formula Tricks and Techniques.
Chapter 4: Understanding Excel's Files.
PART II: Excel Application Development.
Chapter 5: What is a Spreadsheet Application?
Chapter 6: Essentials of Spreadsheet Application Development.
PART III: Understanding Visual Basic for Applications.
Chapter 7: Introducing Visual Basic for Applications.
Chapter 8: VBA Programming Fundamentals.
Chapter 9: Working with VBA Sub Procedures.
Chapter 10: Creating Function Procedures.
Chapter 11: VBA Programming Examples and Techniques.
PART IV: Working with UserForms.
Chapter 12: Custom Dialog Box Alternatives.
Chapter 13: Introducing UserForms.
Chapter 14: UserForm Examples.
Chapter 15: Advanced UserForm Techniques.
PART V: Advanced Programming Techniques.
Chapter 16: Developing Excel Utilities with VBA.
Chapter 17: Working with Pivot Tables.
Chapter 18: Working with Charts.
Chapter 19: Understanding Excel's Events.
Chapter 20: Interacting with Other Applications.
Chapter 21: Creating and Using Add-Ins.
PART VI: Developing Applications.
Chapter 22: Creating Custom Toolbars.
Chapter 23: Creating Custom Menus.
Chapter 24: Providing Help for Your Applications.
Chapter 25: Developing User-Oriented Applications.
PART VII: Other Topics.
Chapter 26: Compatibility Issues.
Chapter 27: Manipulating Files with VBA.
Chapter 28: Manipulating Visual Basic Components.
Chapter 29: Understanding Class Modules.
Chapter 30: Frequently Asked Questions about Excel Programming.
Appendix A: Excel Resources Online.
Appendix B: VBA Statements and Functions Reference.
Appendix C: VBA Error Codes.
Appendix D: ANSI Code Reference.
Appendix E: What's on the CD-ROM.
Index.
End-User License Agreement.
CD-ROM Installation Instructions.
