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;
- Deep dive into concepts for more in-depth VBA programming;
- Enhanced functionality with VBA examples to help you leap forward;
- Diverse applications for truly mastering VBA.
This book provides a comprehensive and progressive introduction to VBA design methods in Excel. It covers Excel's operational environment and 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 in VBA macro language, customizing 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 content is rich and detailed, using real-world scenarios encountered in the workplace as teaching examples to guide readers in learning and mastering VBA syntax and structure. Through this book, readers will gain the methods and skills for VBA programming in the Excel environment, thereby improving their office efficiency.