Contextures

Get Started With Excel Macros

Use Excel macros (VBA) to automate tasks, to save time and reduce errors. These short videos will help you get started

NOTE: Running some macros can wipe out Excel's Undo stack, so you won't be able to undo any steps you've previously taken.

Record and Test a Macro

You can turn on the macro recorder while you do a task in Excel, and then test the macro that you recorded.

Watch this video to see the steps, and see the written instructions here: Record and Test Macro

Edit a Recorded Macro

After you record a macro, you might need to make minor adjustments to the VBA code, so that the macro is more flexible.

edit a recorded macro

Watch this video to see the steps, and see the written instructions here: Edit a Recorded Macro

Show a Message in Excel

With a macro, you can show a message to users, to give information or a warning.

Watch this video to see the steps, and see the written instructions here: Show a Message to Users

Show a Message Automatically

With a macro, you can show a message automatically, when something happens in Excel, to give information or a warning.

Watch this video to see the steps, and see the written instructions here: Show a Message Automatically

Show a Message Before Printing

In this macro, a message shows automatically when someone tries to print the worksheet.

Watch this video to see the steps, and see the written instructions here: Show a Message Before Printing

Excel VBA Tutorials

Add Code to Excel Workbook

Worksheet Macro Buttons

Create an Excel UserForm

Last updated: May 1, 2022 12:09 PM