Excel Macro Execution Basics

The main purpose of this Book is to help you work with the most basic tools and features that allow you to execute macros.

This Book has two main goals:

#1. Help you understand how to execute macros in practice. For these purposes, this Book shows you (step-by-step) the most common processes you follow to execute macros in Excel.

#2. Help you understand the rules and logic behind each of the most common processes you use to execute macros in Excel. This includes understanding, among others: (i) The main consequences of working with the different tools and features you can use to execute macros; (ii) The main criteria to determine which tool or feature to use when executing a macro; and (iii) The main rules and considerations to keep in mind when executing macros.

This Book is divided in six Chapters.

#1. Chapter 1 is an introduction to the topic of macro execution.

#2. In Chapter 2, you learn: (i) How to assign a keyboard shortcut to a macro; and (ii) How to change an existing macro keyboard shortcut.

#3. In Chapter 3, you learn how to assign macros to: (i) Form Controls, particularly Command Buttons; and (ii) Inserted objects, such as Text Boxes.

#4. In Chapter 4, you learn how to add buttons (from which you can execute macros) to both: (i) The Quick Access Toolbar; and (ii) The Ribbon.

#5. In Chapter 5, you learn how to execute a macro from the Macro dialog box.

#6. In Chapter 6, you learn how to execute a macro with the Run Sub/UserForm command of the Visual Basic Editor (VBE).