GET ULTIMATE EXCEL

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

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2022 ExcelVbaIsFun
X

Forgot Password?

Join Us

0
    0
    Your Cart
    Your cart is emptyReturn to Shop
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram