Length: 45 pages.

The main purpose of Introduction to Excel Macros and VBA is to:

• Introduce you to the wonderful world of Excel macros and VBA.
• Help you kickstart the process of learning about Excel macros and VBA.

By purchasing Introduction to Excel Macros and VBA, you take your first step towards becoming a more powerful and efficient Excel user. Becoming a powerful and efficient Excel user has the potential to help you in several ways.

Introduction to Excel Macros and VBA is divided into 4 Chapters.

• In Chapter 1, you learn what macros, VBA, and other related terms refer to.
• In Chapter 2, you learn how macros and VBA can help you become a more efficient and powerful Excel user.
• In Chapter 3, you learn about some important characteristics of macros and VBA. A good understanding of these characteristics should help you better understand some potential pitfalls you may want to avoid while using macros and VBA.
• In Chapter 4, you learn tips and strategies that help you approach learning about macros and VBA. These tips and strategies should help you understand how learning about macros and VBA can be easy and interesting.

Length: 77 pages.

Companion Files: 3 Excel workbooks.

The main purpose of Create Excel Macros Without Programming is to help you:

• During the first stages of learning how to work with macros and VBA.
• Start creating macros without programming.

I'm mindful that to learn about, and master, Excel macros and VBA you need to take the right approach.

My experience is that the main reason people shy away from working with macros and VBA is because these tools are (usually) associated with programming.

The association several people make between macros and programming isn't always correct. You can work with basic macros without programming.

In other words: Excel has a set of tools and features that allow you to start creating, and working with, macros even if you have no programming knowledge or experience.

In Create Excel Macros Without Programming, you learn about certain Excel tools and features that are designed to help you work with, and learn about, macros. You can apply the principles, processes, and strategies you learn in Create Excel Macros Without Programming to create basic but powerful macros.

In the short term, Create Excel Macros Without Programming should help you start creating basic but useful macros. In the medium and long term, the tools and features you learn about help build the knowledge foundation you need to become a powerful Excel macro and VBA user.

Create Excel Macros Without Programming is divided into 7 Chapters.

• In Chapter 1, you learn how to set up Excel to work with macros and VBA.
• In Chapter 2, you learn about the tool (known as the Macro Recorder) you work with when creating Excel macros without programming.
• In Chapter 3, you learn how to plan and prepare prior to creating a macro without programming.
• In Chapter 4, you learn about one of the most important choices you make prior to recording a macro: Whether to use absolute or relative cell references.
• In Chapter 5, you learn the step-by-step process you can follow to create Excel macros without programming.
• In Chapter 6, you learn:
  • About the main limitations of the Macro Recorder; and
  • How to determine whether a specific situation is suitable for using the Macro Recorder.
• In Chapter 7, you learn how to delete (recorded) macros from Excel.
  

Length: 46 pages.

The main purpose of Introduction to Excel Macro Security and Storage is to show you how to work with the main Excel macro and VBA security features and storage options to:

• Reduce the risks that macros and VBA may generate; and
• Increase your power and efficiency when working with macros and VBA.

As you learn in Introduction to Excel Macro Security and Storage:

• You cannot fully eliminate the risks associated with Excel files, even if you do not use macros or VBA.
• Microsoft Windows and Microsoft Office have several security features that have an important influence on how you work with Excel macros and VBA.
• Macro and VBA security is, to a certain extent, related to storage. Having a basic understanding of Excel's storage options helps you:
  • Reduce the risks that macros and VBA may generate; and
  • Increase your power and efficiency when working with macros and VBA.

One of the main goals of Introduction to Excel Macro Security and Storage is to help you gain the knowledge you need to make an informed decision about the following:

• The appropriate macro and VBA security settings for your specific situation.
• How (and where) to store your macros and macro-containing Excel workbooks.

After reading Introduction to Excel Macro Security and Storage, you should be in a better position to work with the main Excel macro and VBA security features and storage options in a way that:

• You reduce (to the extent possible) the risks associated to working with Excel; while
• Being able to harness the power of macros and VBA to increase your power and efficiency.

Introduction to Excel Macro Security and Storage is divided into 5 Chapters.

• Chapter 1 is an introduction to the topic of macro and VBA security.
• In Chapter 2, you learn how to specify Global Macro Security Settings. In other words: You learn:
  • How to specify whether macros are enabled (or disabled) by default; and
  • The main consequences of each of the available Global Macro Security Settings.
• In Chapter 3, you learn about 2 specific features (Trusted Locations and Trusted Publishers) that allow you to further control and influence the way your computer deals with Excel files containing macros.
• In Chapter 4, you learn about the different Excel file types. This includes learning:
  • Which Excel file types can (and which ones cannot) contain macros; and
  • How to save Excel workbooks that contain macros.
• In Chapter 5, you learn about a special Excel workbook (known as the Personal Macro Workbook) you can use to store commonly used macros.

Length: 58 pages.

The main purpose of Excel Macro Execution Basics is to help you work with the most basic tools and features that allow you to execute macros.

Excel Macro Execution Basics has 2 main goals:

1. Help you understand how to execute macros in practice. Excel Macro Execution Basics 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:
   1. The main consequences of working with the different tools and features you can use to execute macros;
   2. The main criteria to determine which tool or feature to use when executing a macro; and
   3. The main rules and suggestions to consider when executing macros.

Excel Macro Execution Basics is divided into 6 Chapters.

• Chapter 1 is an introduction to the topic of macro execution.
• In Chapter 2, you learn:
  • How to assign a keyboard shortcut to a macro; and
  • How to change an existing macro keyboard shortcut.
• In Chapter 3, you learn how to assign macros to:
  • Form Controls, particularly Command Buttons; and
  • Inserted objects, such as Text Boxes.
• In Chapter 4, you learn how to add buttons (from which you can execute macros) to (both):
  • The Quick Access Toolbar; and
  • The Ribbon.
• In Chapter 5, you learn how to execute a macro from the Macro dialog box.
• In Chapter 6, you learn how to execute a macro with the Run Sub/UserForm command of the Visual Basic Editor (VBE).

Length: 101 pages.

The main purpose of Visual Basic Editor (VBE) Basics is to help you learn the basics of working with the Visual Basic Editor (VBE).

Visual Basic Editor (VBE) Basics:

• Is part of my Excel Macros for Beginners Book Series; and
• Assumes you know about the topics covered in the previous Books in the Excel Macros for Beginners Book Series, particularly Create Excel Macros Without Programming.

Visual Basic Editor (VBE) Basics has 2 main goals:

1. Help you learn the basics of working with the Visual Basic Editor (VBE). Visual Basic Editor (VBE) Basics introduces and explains (among others):
   1. The VBE and its main characteristics/components/sections; and
   2. How to use the VBE to carry out the most common activities and operations you (an Excel macro and VBA beginner) are likely to require for achieving your objectives.
2. Introduce several useful tools, features, and customizations you (an Excel macro and VBA beginner) may find helpful.

Visual Basic Editor (VBE) Basics does not cover every single detail of working with the Visual Basic Editor (VBE). It focuses on the information, details, and processes that (in my opinion) are helpful to an Excel macro and VBA beginner.

Visual Basic Editor (VBE) Basics is divided into 9 Chapters.

• Chapter 1 is an introduction to the Visual Basic Editor (VBE).
• In Chapter 2, you learn how to access the VBE, including how to:
  • Open the VBE; and
  • Toggle between Excel and the VBE.
• In Chapter 3, you learn how to work with one of the most often used VBE windows: The Project Explorer (or Project Window).
• In Chapter 4, you learn how to work with modules. You can (usually) think of modules as containers of VBA code.
• In Chapter 5, you learn how to work with another (in addition to the Project Explorer) of the most often used VBE windows: The Code Window.
• Chapter 6 is an introduction to working with VBA code in the VBE. This Chapter focuses on the perspective of Excel macro beginners who (usually) create macros by working with the Macro Recorder.
• Chapter 7 is an introduction to:
  • VBE customization; and
  • VBE window behavior. This includes step-by-step explanations of the processes you can use to specify or modify VBE window behavior.
• In Chapter 8, you learn how to work with 2 tools that help you while creating macros:
  • The Interpreter; and
  • Auto Syntax Check.
• In Chapter 9, you learn how to modify (to a certain extent) the appearance of:
  • The VBE; and
  • The VBA code you work with.

Length: 35 pages.

Companion Files: 3 Excel workbooks.

The main purpose of Introduction to Excel VBA Procedures and Sub Procedures is to introduce the basic syntax/structure of VBA procedures and Sub procedures.

Introduction to Excel VBA Procedures and Sub Procedures:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in my previous Book Series, particularly the Excel Macros for Beginners Book Series.

Introduction to Excel VBA Procedures and Sub Procedures has 2 main goals:

1. Introduce:
   1. What procedures and Sub procedures are; and
   2. Why procedures and Sub procedures are essential VBA constructs.
2. Help you learn the basics of creating, and working with, procedures and Sub procedures. To achieve this, Introduction to Excel VBA Procedures and Sub Procedures introduces and explains (among others):
   1. How to work with, and identify, procedures in the Visual Basic Editor (VBE);
   2. The basic elements and syntax/structure of a Sub procedure; and
   3. The mandatory rules and main good practices to follow when naming procedures.

Introduction to Excel VBA Procedures and Sub Procedures does not cover every single detail of creating, or working with, procedures and Sub procedures. It's an introduction to the basic concepts, constructs, and structures that (in my opinion) are helpful to an Excel VBA beginner.

Introduction to Excel VBA Procedures and Sub Procedures is divided into 3 Chapters.

• Chapter 1 is an introduction to procedures and Sub procedures.
• In Chapter 2, you learn how to create basic Sub procedures.
• In Chapter 3, you learn the mandatory rules and main good practices to follow when naming procedures.

Length: 47 pages.

Companion Files: 2 Excel workbooks.

The main purpose of VBA Statement Basics is to introduce the basic components and syntax/structure of VBA statements.

You build on this basic knowledge as you continue learning about VBA. By having a good understanding of these topics, you're likely to be in a better position to:

• Organize the VBA constructs you work with; and
• Create VBA statements that:
  • Excel can understand; and
  • Lead to the results you expect.

VBA Statement Basics:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series, particularly Introduction to Excel VBA Procedures and Sub Procedures.

VBA Statement Basics:

• Does not cover every single detail of creating, or working with, VBA statements or constructs.
• Is an introduction to the basic concepts, constructs, and structures that (in my opinion) are helpful to an Excel VBA beginner.

VBA Statement Basics is divided into 3 Chapters.

• Chapter 1 is an introduction to the basic structure and elements of the VBA language.
• In Chapter 2, you learn about the basic components of the VBA language.
• In Chapter 3, you learn the basic syntax/structure of a VBA statement.

Length: 109 pages.

Companion Files: 3 Excel workbooks.

The main purpose of Introduction to the Excel VBA Object Model and Object References is to give you an introduction to the following 2 topics, which are essential for Excel VBA users:

• The Excel VBA Object Model; and
• Object references.

Objects are one of the most important VBA constructs. Having a good understanding of objects, the Excel Object Model, and object references is essential when working with VBA.

Introduction to the Excel VBA Object Model and Object References:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series.

Introduction to the Excel VBA Object Model and Object References is divided into 5 Chapters.

• Chapter 1 is an introduction to the importance of objects.
• Chapter 2 is an introduction to the Excel Object Model.
• In Chapter 3, you learn:
  • What collection are; and
  • How to work with collections.
• In Chapter 4, you learn the basic process you can follow to refer to an object.
• Chapter 5 contains several practical examples to help you practice creating procedures that refer to, and select/activate, an object.

Length: 113 pages.

Companion Files: 4 Excel workbooks.

The main purpose of Introduction to Properties, Methods and Parameters in Excel VBA is to help you work with the following 3 (essential) VBA constructs:

• Properties;
• Methods; and
• Parameters.

These are 3 of the most important VBA constructs. Having a good understanding of them is essential when working with VBA.

Introduction to Properties, Methods and Parameters in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series.

Introduction to Properties, Methods and Parameters in Excel VBA is divided into 4 Chapters.

• Chapter 1 is an introduction to the following 3 VBA constructs:
  • Properties;
  • Methods; and
  • Parameters.
• In Chapter 2, you learn how to work with:
  • Properties;
  • Methods; and
  • Parameters.
• In Chapter 3, you learn about built-in (also known as system-defined or intrinsic) constants.
• Chapter 4 contains several practical examples to help you practice creating procedures that work with/manipulate objects using:
  • Properties;
  • Methods; and
  • Parameters.

Length: 94 pages.

Companion Files: 4 Excel workbooks.

The main purpose of With… End With Blocks in Excel VBA is to:

• Introduce a VBA construct known as the With… End With block (or statement); and
• Explain how you can use the With… End With block to improve (among others) the structure and efficiency of your VBA code.

The With… End With block is one of the main constructs you can use to efficiently refer to objects. Since you're bound to work with VBA objects often, you're likely to find the With… End With block helpful.

With… End With Blocks in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series.

With… End With Blocks in Excel VBA is divided into 3 Chapters.

• Chapter 1 is an introduction to the basics of working with the With… End With block.
• In Chapter 2, you learn how (and when) to nest With… End With blocks.
• Chapter 3 contains several practical examples to help you practice creating/improving procedures with the With… End With block.

Length: 109 pages.

Companion Files: 5 Excel workbooks.

The main purpose of Formulas, Cell References, Expressions and Operators in Excel VBA is to help you learn how to work with the following constructs in Excel VBA:

• Formulas.
• Cell references.
• Expressions.
• Operators.

The 4 constructs I list above:

• Are essential when working with VBA.
• Have, to a certain extent, important similarities with constructs you (as an Excel user) are probably familiar with.

Your pre-existing knowledge about Excel continues to be useful as you learn about the constructs covered in Formulas, Cell References, Expressions and Operators in Excel VBA. There are some specific considerations that apply when you work with these constructs in VBA.

Formulas, Cell References, Expressions and Operators in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series.

Formulas, Cell References, Expressions and Operators in Excel VBA is divided into 5 Chapters.

• Chapter 1 is an introduction to the topic of formulas and cell references in Excel/VBA.
• In Chapter 2, you learn how to work with a cell-referencing style (known as R1C1) that is useful in VBA.
• Chapter 3 contains a detailed practical example to help you practice working with R1C1-style references in VBA.
• In Chapter 4, you learn how to work with expressions and operators in VBA.
• Chapter 5 contains several practical examples to help you practice working with expressions and operators in VBA.

Length: 199 pages.

Companion Files: 8 Excel workbooks.

The main purpose of Variables, Data Types and User-Defined Constants in Excel VBA is to help you work with the following VBA constructs.

• Variables, including object variables.
• Data types.
• User-defined (or symbolic) constants.

Variables and constants help you, Excel, and VBA work more efficiently with data. When you work with VBA, you're likely to often deal with variables and constants.

Variables, Data Types and User-Defined Constants in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series.

Variables, Data Types and User-Defined Constants in Excel VBA is divided into 8 Chapters.

• Chapter 1 is an introduction to variables and data types.
• In Chapter 2, you learn how to declare variables and data types.
• In Chapter 3, you learn about the main data types you can work with.
• In Chapter 4, you learn how to assign data to variables.
• In Chapter 5, you learn about variable scope and lifetime.
• Chapter 6 contains several practical examples to help you practice working with variables in VBA.
• In Chapter 7, you learn how to work with object variables.
• In Chapter 8, you learn how to work with user-defined (or symbolic) constants.

Length: 79 pages.

Companion Files: 6 Excel workbooks.

The main purpose of Arrays in Excel VBA is to help you work with VBA arrays.

Arrays help you, Excel, and VBA work more efficiently with data. When you work with VBA, you're likely to often deal with arrays.

Arrays in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series, particularly Variables, Data Types and User-Defined Constants in Excel VBA.

Your knowledge about variables continues to be useful as you learn about arrays. There are important differences between:

• Regular (or scalar) variables; and
• Arrays.

Arrays in Excel VBA is divided into 6 Chapters.

• Chapter 1 is an introduction to arrays.
• In Chapter 2, you learn how to declare arrays.
• In Chapter 3 and Chapter 4, you learn how to work with the following (more advanced) arrays:
  • Multidimensional arrays; and
  • Dynamic arrays.
• In Chapter 5, you learn how to carry out several basic array operations:
  • Filling an array with data;
  • Getting information from an array; and
  • Erasing array data.
• Chapter 6 contains several practical examples to help you practice working with arrays in VBA.

Length: 84 pages.

Companion Files: 3 Excel workbooks.

The main purpose of Procedure Calling in Excel VBA is to help you make VBA procedures work together by calling procedures.

Procedure calling:

• Is one of the most useful ways of executing procedures.
• Helps you create powerful VBA Projects.

Procedure Calling in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series, particularly:
    • Introduction to Excel VBA Procedures and Sub Procedures;
    • Variables, Data Types and User-Defined Constants in Excel VBA; and
    • Arrays in Excel VBA.

Procedure Calling in Excel VBA is divided into 3 Chapters.

• In Chapter 1, you learn:
  • What the term "procedure calling" refers to;
  • The importance of procedure calling when working in VBA; and
  • How to call procedures.
• In Chapter 2, you learn:
  • What the term "procedure scope" refers to; and
  • The importance of procedure scope when working in VBA.
• In Chapter 3, you learn how to:
  • Pass data between procedures; and
  • Work with procedure arguments.

Length: 89 pages.

Companion Files: 4 Excel workbooks.

The main purpose of Functions in Excel VBA is to help you work with functions in Excel VBA. You can work with 3 types of functions in VBA:

• VBA built-in (or intrinsic) functions.
• Excel worksheet functions.
• User-Defined Functions (UDFs).

Functions in Excel VBA focuses on the first 2 types of functions above. UDFs are covered (in detail) in User-Defined Functions (UDFs) in Excel VBA.

As you learn in Functions in Excel VBA:

• Functions play an important role in VBA.
• Working with functions in VBA has, to a certain extent, important similarities with working with functions in regular Excel.

Your pre-existing knowledge about Excel continues to be useful as you learn how to work with functions in VBA. There are some specific considerations that apply when you work with functions in VBA.

Functions in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series.

Functions in Excel VBA is divided into 5 Chapters.

• Chapter 1 is an introduction to working with functions in VBA.
• In Chapter 2, you learn how to work with VBA built-in functions.
• Chapter 3 contains several examples to help you practice working with VBA built-in functions.
• In Chapter 4, you learn how to work with Excel worksheet functions in VBA.
• Chapter 5 contains several examples to help you practice working with Excel worksheet functions in VBA.

Length: 142 pages.

Companion Files: 6 Excel workbooks.

The main purpose of User-Defined Functions (UDFs) in Excel VBA is to help you work with User-Defined Functions (UDFs) in Excel VBA. You can work with 3 types of functions in VBA:

• VBA built-in (or intrinsic) functions.
• Excel worksheet functions.
• User-Defined Functions (UDFs).

User-Defined Functions (UDFs) in Excel VBA focuses on UDFs. VBA built-in functions and Excel worksheet functions are covered (in detail) in Functions in Excel VBA.

As you learn in User-Defined Functions (UDFs) in Excel VBA:

• Working with UDFs has several advantages; and
• UDFs play an important role in VBA.

When you work with VBA, you're likely to often create (and work with) UDFs.

User-Defined Functions (UDFs) in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series, particularly:
    • Introduction to Excel VBA Procedures and Sub Procedures;
    • Variables, Data Types and User-Defined Constants in Excel VBA;
    • Procedure Calling in Excel VBA; and
    • Functions in Excel VBA.

User-Defined Functions (UDFs) in Excel VBA is divided into 5 Chapters.

• Chapter 1 is an introduction to User-Defined Functions (UDFs).
• In Chapter 2, you learn how to create UDFs.
• In Chapter 3, you learn how to call UDFs.
• In Chapter 4, you learn how to customize UDFs.
• Chapter 5 contains several examples to help you practice creating UDFs.

Length: 103 pages.

Companion Files: 6 Excel workbooks.

The main purpose of Control Flow and Decision-Making in Excel VBA is to help you:

• Specify a procedure's control flow; and
• Create procedures that make decisions.

The ability to do the above:

• Allows you to create even more powerful procedures; and
• Explains a substantial part of VBA's power.

Control Flow and Decision-Making in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series.

Control Flow and Decision-Making in Excel VBA is divided into 6 Chapters.

• Chapter 1 is an introduction to the concept of control flow in VBA.
• In Chapter 2, you learn how to work with:
  • Labels; and
  • The GoTo statement.
• In Chapter 3, you learn how to work with:
  • Logical expressions; and
  • Conditional tests.
• In Chapter 4, you learn how to work with:
  • The If… Then… Else statement; and
  • The IIf VBA built-in function.
• Chapter 5 contains examples to help you practice working with the If… Then… Else statement.
• In Chapter 6, you learn how to work with the Select Case statement.

Length: 61 pages.

Companion Files: 3 Excel workbooks.

The main purpose of Error Handling in Excel VBA is to help you handle errors in VBA.

As you learn in Error Handling in Excel VBA:

• Errors may happen.
• One of your (main) objectives when programming is to avoid errors.
• In practice, VBA users of all levels (from beginner to advanced) must (from time to time) deal with errors.
• You (generally) do not want errors to occur when a user executes a procedure.

Because of the above:

• Error handling is an essential skill for (virtually) any VBA Developer (like you).
• You're likely to often deal with (and handle) errors.

Error Handling in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series, particularly Control Flow and Decision-Making in Excel VBA.

Error Handling in Excel VBA is divided into 4 Chapters.

• Chapter 1 is an introduction to errors in VBA.
• Chapter 2 is an introduction to error handling in VBA.
• In Chapter 3, you learn:
  • About error trapping settings; and
  • How to specify the appropriate error trapping settings to handle errors.
• In Chapter 4, you learn how to work with the basic error handling construct in Excel VBA: The On Error statement.

Length: 156 pages.

Companion Files: 6 Excel workbooks.

The main purpose of Loops in Excel VBA is to help you learn how to create procedures that repeatedly execute a set of statements. You achieve this by working with loops.

The ability to repeatedly execute a set of statements in a procedure:

• Allows you to create even more powerful procedures; and
• Explains a substantial part of VBA's power.

Loops in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series, particularly Control Flow and Decision-Making in Excel VBA.

Loops in Excel VBA is divided into 6 Chapters.

• Chapter 1 is an introduction to loops in VBA.
• In Chapter 2, you learn how to work with one of the main types of VBA loops: Fixed iteration loops.
• Chapter 3 contains examples to help you practice working with fixed iteration loops.
• In Chapter 4, you learn how to work with the second (main) type of VBA loop: Indefinite loops.
• Chapter 5 contains examples to help you practice working with indefinite loops.
• In Chapter 6, you learn:
  • How (and when) to nest loops; and
  • How to avoid (or handle) infinite loops.

Length: 108 pages.

Companion Files: 1 cheat sheet (45 pages) + 6 Excel workbooks + 1 example PDF file.

The main purpose of Introduction to Events in Excel VBA is to help you:

• Work with events; and
• Create procedures that are executed automatically:
  • When an event occurs; and
  • Without having to take additional action.

As you learn in Introduction to Events in Excel VBA:

• The (main) reason events are important in VBA is the fact that VBA allows you to monitor (certain) events. Once such an event occurs, VBA recognizes this.
• You can use this information to automatically execute a procedure upon a specific (monitored) event occurring.

Introduction to Events in Excel VBA:

• Is part of my VBA Fundamentals Book Series; and
• Assumes you know about the topics covered in:
  • My previous Book Series, particularly the Excel Macros for Beginners Book Series; and
  • The previous Books in the VBA Fundamentals Book Series, particularly:
    • Procedure Calling in Excel VBA; and
    • Variables, Data Types and User-Defined Constants in Excel VBA.

Introduction to Events in Excel VBA is divided into 4 Chapters.

• Chapter 1 is an introduction to events in VBA.
• In Chapter 2, you learn:
  • What event handler procedures are; and
  • How to create and store event handler procedures.
• In Chapter 3, you learn:
  • What event sequences are; and
  • How to enable or disable event monitoring.
• Chapter 4 contains examples to help you practice working with:
  • Events; and
  • Event handler procedures.