Beginner's Guide to VBA 5

Designed as a beginner's guide to VBA 5, this book covers essential theory as well as real-life solutions and strategies, and provides solutions to common programming tasks and business problems.

Readers can copy the answers directly into their applications and thus have a complete source of VBA business tools usable and ready to run.

Part I explores reasons for using VBA as a development language and environment as well as the types of applications.

Part II covers the VBA language in depth. Part III delves into the meat of VBA programming: manipulating objects in host applications.

In Part IV, readers learn to create their own objects.

Part V shows a some advanced techniques. Part VI presents two case studies and moderately complex, real applications to further stimulate readers' understanding of the potential in VBA programming.

This section also ties together all of the concepts in the book.