Excel Macro Editor Basics

Excel macro dialog box.

This Excel tutorial is the follow up to the previous article we did on using Excel’s built-in macro recorder. It will introduce you to the macro editor and layout so you can create or edit your own macros. It’s also a great way to learn how the macros work.

Simplifying the Excel Macro Recorder

Record macro dialog box

Certain words seem to scare folks when it comes to Microsoft Excel. One is “macro.” But what if I told you Excel could capture your keystrokes and clicks and turn the sequence into a macro? The feature is called the Excel Macro Recorder, and it does the heavy lifting for you. In this tutorial and video, I’ll show how to record a macro in Excel. And you don’t need to know Visual Basic for Applications (VBA code).


Use VBA Function to Show Excel Filter Criteria

excel with filter criteria displayed

Have you ever received an Excel file and wondered how it was filtered without checking each column’s data filter? Or, maybe you needed to send a file and show your filters. That was a problem I faced recently when I started with a list of 3200 non-profits for the county. I needed a way for Excel to show the filters and logic. (Includes Excel practice spreadsheet with VBA code.)