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.

Simplify Your Workflow: Learn How to Use Excel Macro Recorder

Record macro dialog box

Want to make your Excel tasks easier and faster? The Excel Macro Recorder can automate your repetitive tasks by recording your actions. Envision the efficiency of having Excel handle 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.)