Excel 304 - Creating Worksheet Macros & VBA Basics
Product Description
8-page bi-fold.
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 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.
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.
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 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.
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.