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..

Open Visual Basic Editor

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

 

 

Create a Module

(something to put code into).

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.

X

Forgot Password?

Join Us