Enroll In My FREE VBA Crash Course For FREE!
Learn how to write macros from scratch, make buttons and simple procedures to automate tasks.

[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″]
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”]
(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”]
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]