How to Enable the Developer Tab in Excel for Windows
Bottom Line: Learn how to enable the Developer tab on the ribbon so that you can access commonly used functions for Macros, VBA, and Add-ins. Works on all versions of Excel for Windows (Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Office 365).
Skill Level: Beginner
Keyboard Shortcuts for the VBA Intellisense Drop-down Menu
Bottom line: Learn two keyboard shortcuts for displaying the Intellisense menu, so you can autocomplete words in the VB editor.
Skill level: Intermediate
8
How to Create VBA Macro Buttons for Filters in Excel
Bottom line: Learn how to create macro buttons that apply filters to multiple columns in a filtered range or Table.
Skill level: Intermediate
How to Clear Filters with VBA Macros
Bottom line: Learn how to clear all filters, and filters on a single column with VBA macros. Includes code examples for regular ranges and Excel Tables.
Skill level: Intermediate
How to Filter for Colors & Icons with VBA Macros in Excel
Bottom line: Learn how to apply color and icon filters with VBA. Includes examples for filtering for font color, fill color, and conditional formatting icons.
Skill level: Intermediate
1
How to Filter for Numbers with VBA Macros in Excel
Bottom line: Learn how to apply number filters with VBA. Includes examples for filtering for a range between two numbers, top/bottom 10, above/below average, etc.
Skill level: Intermediate
2
How to Filter for Blanks and Non-Blank Cells with VBA Macros
Bottom line: Learn how to apply filters for blank cells with VBA. Includes examples for filtering blanks and non-blank cells using the AutoFilter method.
Skill level: Intermediate
22
The Ultimate Guide to Excel Filters with VBA Macros – AutoFilter Method
Bottom line: Learn how to create macros that apply filters to ranges and Tables with the AutoFilter method in VBA. The post contains links to examples for filtering different data types including text, numbers, dates, colors, and icons.
Skill level: Intermediate
1
How to Filter for Dates with VBA Macros in Excel
Bottom line: Learn how to apply date filters with VBA. Includes examples for filtering for a range between two dates, date groups from filter drop-down list, dynamic dates in period, etc.
Skill level: Intermediate
How to Filter for Text with VBA Macros in Excel
Bottom line: Learn how to apply text filters with VBA. Includes examples for filtering for multiple items, begins with, contains, wildcards, etc.
Skill level: Intermediate
