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

FAQs, Excel VBA, Excel Macros  

Adding Code to an Excel Workbook

Worksheet Macro Buttons

Create an Excel UserForm

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search Contextures Sites

 

Excel Tools Add-in

 

Free Pivot Table Tools

 

 

 

Last updated: October 4, 2016 7:10 PM
Contextures RSS Feed