Product Overview
Four page laminated quick reference guide that will open the world of Microsoft Office automation in Word, Excel, PowerPoint and Access. You will learn how to modify macros, customize functions and create your own programming. Written with Beezix's trademark focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource for composing Visual Basic for Applications code. Geared toward the intermediate to advanced Microsoft Office 2013 user.
The following topics are covered:
Getting Started: Showing the Developer Tab; Setting Macro Security; Opening a Code Window; Deleting a Code Window; Saving Code; Project Explorer Names; Code Name Rules; VBA Editor tips; Password Protect Code & Understanding the VBA Language.
Create VBA Subroutines: Useful Code Events; Navigating Code Window Lists: Object List Items and Procedure List Items.
Organizing Code: Variables and Constants for Efficiency; Good Practices with Variables; Sophistication with VBA Functions: Useful VBA Function Categories; Decision Power with IF and SELECT & Eliminate Repeats with FOR and DO.
Other Topics: Reach Out to Users; Troubleshooting & VBA Code Tips.
A wide variety of examples provided for the following: Keyboard Shortcuts; Constructing a Code Statement; Simple Code; Variables; Code Decisions; Eliminating Repeats & Interacting with Users.
