官术网_书友最值得收藏!

Using the VBA Editor

We've worked with the VBA Editor before, but that was on another file, with a different Sub procedure. The recipe we're going to work with here will show you how to activate the VBA Editor in your own file. Furthermore, we're going to identify various components within the editor.

Getting ready

With 02_RecordMacro.xlsx still open, we're going to activate the VBA Editor. Whether you are on Sheet1, Sheet2, or Sheet3 is of no consequence, because the macro is part of the workbook.

How to do it…

Let's go through the steps for this recipe:

  1. The standard way to activate the VBA Editor is to navigate to Developer | Code | Macros, and then select Edit on the Macro dialog box.
  2. The shortcut key makes life much easier. Simply hold down the Alt key while pressing F11. This time, you bypass the dialog box by going straight to the VBA Editor:

Figure 1.15 – A Sub procedure in the VBA Editor

The evidence of what we recorded is displayed in the code window.

How it works…

Opening the VBA Editor can be done in one of two ways: with the Alt + F11 keyboard shortcut, or by clicking on Edit in the Macro dialog box.

In the VBA Editor, you will find the following basic components:

Figure 1.16 – Components of the VBA Editor

There's more…

Each element, or component, of the VBA Editor has a specific function. Up until now, we've only used the code window. In future recipes, we will be referring to and using the other elements.

主站蜘蛛池模板: 滦平县| 天长市| 县级市| 宁乡县| 黑水县| 永善县| 昌江| 赤城县| 昭苏县| 麦盖提县| 遵化市| 比如县| 安溪县| 镇宁| 连州市| 陇西县| 牡丹江市| 仁布县| 墨江| 宁阳县| 巍山| 泰和县| 定结县| 左云县| 安龙县| 阳原县| 伊金霍洛旗| 德惠市| 保靖县| 巴青县| 呈贡县| 南安市| 西城区| 伊春市| 衡山县| 漯河市| 宜宾县| 苗栗市| 察哈| 永嘉县| 休宁县|