[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]