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

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.

主站蜘蛛池模板: 禹城市| 翁牛特旗| 徐州市| 双辽市| 南通市| 牙克石市| 岳普湖县| 石阡县| 增城市| 广宁县| 两当县| 哈密市| 沅江市| 公主岭市| 台江县| 平湖市| 循化| 河北区| 江华| 孝感市| 东乌珠穆沁旗| 丽水市| 宜君县| 霍邱县| 平武县| 梁平县| 山阳县| 惠安县| 连州市| 吉隆县| 兴安盟| 香港 | 响水县| 罗田县| 阳西县| 霍山县| 凌云县| 名山县| 万州区| 长寿区| 郓城县|