[et_pb_section fb_built=”1″ _builder_version=”3.27.3″ fb_built=”1″ _i=”0″ _address=”0″][et_pb_row _builder_version=”3.27.3″][et_pb_column _builder_version=”3.27.3″ type=”4_4″][et_pb_text _builder_version=”3.27.3″ hover_enabled=”0″]

If you’re first getting started in Excel VBA, try these first steps in order to access the code section of your Excel workbook. It’s easy! You’ll see..

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”3.27.3″][et_pb_column _builder_version=”3.27.3″ type=”4_4″][et_pb_text _builder_version=”3.27.3″ hover_enabled=”0″]

Open Visual Basic Editor

First, open the hidden Visual Basic Editor (VBE). Press Alt+F11 or click Developer Ribbon -> Visual Basic

[/et_pb_text][et_pb_text _builder_version=”3.27.3″ hover_enabled=”0″ admin_label=”openvbe”]

[/et_pb_text][et_pb_divider _builder_version=”3.27.3″ hover_enabled=”0″][/et_pb_divider][et_pb_text _builder_version=”3.27.3″ hover_enabled=”0″ _i=”0″ _address=”0.0.0.0″ admin_label=”createmodule”]

Create a Module

(something to put code into).

[/et_pb_text][et_pb_divider _builder_version=”3.27.3″ hover_enabled=”0″][/et_pb_divider][et_pb_text _builder_version=”3.27.3″ hover_enabled=”0″ admin_label=”firstmacro”]

Your First Macro

Finally, here’s how to make your first macro. Type SUB, then a spacebar, then give it a name, like TEST123, then hit Enter.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]