EXCEL VBA (2000~2003) Programming

Author: Wang Hongru
Publisher:
Publish Date: 2005-01-01
Features:
- Introduce the basics to easily understand the wonders of VBA;
- Complete introduction to VBA toolbars;
- In-depth analysis of concepts to enhance VBA programming;
- Enhanced functionality with VBA examples to help you leap forward;
- Diverse applications to truly leverage VBA to the fullest.
This book provides a comprehensive and progressive introduction to the design methods of VBA in Excel. It covers the Excel operating environment and Excel macro functions; VB toolbars, VBA editing environment, data and variables, data operations, and flow control; forms and controls, input/output management, error detection in VBA, and arrays; pivot tables, chart objects, commonly used functions of VBA macro language, custom Excel toolbars and menus, creating form wizards, using Excel to access databases, and designing statistical functions, among others. Two practical examples, an accounting ledger system and a questionnaire analysis system, are also included.
The examples in this book can be downloaded from the "Download Zone" on the Tianqin website at: http://www.tqbooks.net. The book is rich in content and detailed in explanation, using real-world scenarios encountered in the workplace as teaching examples to guide readers in learning and familiarizing themselves with VBA syntax and structure. Through this book, readers will master the methods and skills of VBA programming in the Excel environment, thereby improving their office efficiency.