Excel Tricks – Macros and VBA

Fun with Macros

Macros can be useful if you do the same process over and over again.  Here’s how to create one.

  • If you want to ‘record’ steps, Click on Tools, Macro, Record New Macro
  • Type in a name for your Macro and perform all the steps you want to record
  • Click the stop Recording button when done.



If you are familiar with program code, you can also create macros using VBA (Visual Basic for Applications)

Click on Tools, Macro, Macros….

  • A window will appear, Type in a New Name under Macro Name and click Create
  • A VBA editor will appear and you can code and debug your macro.
  • You can also paste in code from macros that other people have created.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s