Visual Basic for Applications (VBA) 2016 Introduction Quick Reference Guide - Windows Version (Cheat Sheet of Instructions, Tips & Examples - Laminated)
R 698
or 4 x payments of R174.50 with
Availability: Currently in Stock
Delivery: 10-20 working days
Visual Basic for Applications (VBA) 2016 Introduction Quick Reference Guide - Windows Version (Cheat Sheet of Instructions, Tips & Examples - Laminated)
Four page, example rich 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 2016 user.
The following topics are covered:
Getting Started: Showing the Developer Tab; Setting Macro Security; Organizing VBA Projects; Opening or Creating Code Windows; Deleting a Code Window; Creating VBA Code; Running VBA Code; Saving Code; Saving Global Macros; Code Name Rules; VBA Editor Tips; Using & Navigating Code Window Lists & Password Protecting Code.
Create VBA Subroutines: Useful Code Events; Understanding the VBA Language & VBA Code Syntax.
Organizing Code:Â Efficiency with Variables; Good Practices with Variables; Decision Power & Good Practices with IF and SELECT & Eliminating Repeats with FOR and DO.
Other Topics: Reaching Out to Users; Troubleshooting; Sophistication with VBA Functions; Useful VBA Function Categories; Troubleshooting; Catching Bugs; Trap Errors; Troubleshooting Tips & VBA Code Tips.
A wide variety of examples provided for the following:Â Useful Keyboard Shortcuts; Simple Code; Variables; Code Decisions; Eliminating Repeats & Reaching Out to Users.