Mastering VBA 6

Visual Basic for Applications offers the ability to automate and customize the behavior of hundreds of VBA-compliant applications. This text gives a solid foundation in VBA programming, then moves on to tutorial-based instruction in specific techniques. Coverage includes: understanding what VBA is and what can be done with it; recording and editing macros in Microsoft Office applications; using the Visual Basic Editor to create and edit code; finding the objects, properties, and methods for procedures; using variables, constants, and arrays to store and manage information; creating loops to repeat actions in your code; using conditions to make decisions between different courses of action; navigating the object models of VBA-compliant applications; creating custom dialog boxes with user forms; building modular code for clarity and easy maintenance; testing and debugging code and user forms; and securing code with digital certificates and VBA 6 security features.