Visual Basic for Applications (VBA) 2013 Quick Reference Guide: Introduction (Cheat Sheet of Instructions, Tips & Examples - Laminated)

Beezix Inc.

ISBN 10: 1939791332 ISBN 13: 9781939791337

Publisher: Beezix Inc., 2014

Synopsis

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.

About this title

About the Author

Beezix has been publishing quick reference computer guides for trainers, training companies, corporations, and individuals across the US and Canada for the past 20 years. Founded by trainers, extensive industry experience made us aware of the need for a line of high-quality guides that were clear, accurate and concise. Our cards are designed for casual computer users right through to trainers and help desk staff.

Edition details

• Publisher: Beezix Inc.
• Publication date: 2014
• ISBN 10: 1939791332
• ISBN 13: 9781939791337
• Binding: Pamphlet
• Language: English
• Number of pages: 4