This is an 8-page bi-fold quick reference guide. This quick reference guide will help you create, edit and troubleshoot macros using the macro recording feature as well as using basic VBA functionality. Recording your steps is the straightforward and can save you time and effort. Once you record your steps, you can run the macro, assign it to an icon on the Quick Access Toolbar, or use a keyboard shortcut. This guide also explains how you can edit macros in the Visual Basic Editor and how to troubleshoot macro errors. An overview of VBA is provided in which procedures, functions, methods, modules, keywords and objects are explained. Several examples are provided on how to write the VBA code, how to debug the code and how to transfer code to other documents. There are numerous other topics covered in this guide as well such as working with macro storage locations, macro security issues, using shortcut keys, and managing macros. The guide wraps up with a discussion focused on creating user-defined forms with dialog box features, buttons, form security and document controls. The guide is also structured to be a companion for hands-on training or self-paced training. It includes step by step instructions and downloadable exercise files.
Trustpilot
3 weeks ago
3 weeks ago
