MICROSOFT EXCEL 2013 Quick Reference Guide - Worksheet Macros & Forms: Creating & Editing Macros, Managing Forms & VBA Overview (304)

Descripción

This 8-page bifold quick reference guide (cheat sheet) offers instructions to 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 workbooks. There are numerous other topics covered in this guide as well such as recording with absolute or relative reference, 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 and worksheet controls. All of our quick guides are developed, designed and published in the US. They are printed on a high-quality sustainable stock that features UV coating which resists fading and spills. Unlike the competition, our guides offer in-depth details, step-by-step exercises, structured content that is based on adult learning concepts and are written by expert instructors who are every day users of the software application. Yes, our guides are priced higher; however, the quality and value found in these guides are far superior to the competition. With our quick reference guides, you can achieve more today, and make a great investment for tomorrow.