Cart

On the most basic level, all you have to do is open up the Visual Basic editor in Excel by going to the developer tab and clicking the visual basic editor button. I prefer to use a keyboard shortcut (Alt + F11) to open up the Visual Basic editor.

To create your first macro, you need to add a new module:

Once you’re in the a new module, we need to create our first macro. In this example, we call it test123 and hit enter a few times.