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.
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
After you record a macro, you might need to make minor adjustments to the VBA code, so that the macro is more flexible.
Watch this video to see the steps, and see the written instructions here: Edit a Recorded Macro
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
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
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
Last updated: May 1, 2022 12:09 PM