How to filter as you type with VBA in Excel

How to filter as you type with VBA in Excel

by | Nov 29, 2022 | Excel Tips & Tricks

Excel has rich resources on filtering as expected from a spreadsheet software. However, the functionality may lack fanciness in a business software, like filtering on-the-fly as users are typing. Fortunately, Excel has enough customization tools to add such a feature...
How to filter as you type without VBA in Excel

How to filter as you type without VBA in Excel

by | Nov 29, 2022 | Excel Tips & Tricks

Excel has rich resources on filtering as expected from a spreadsheet software. However, the functionality may lack of fanciness in a business software, like filtering on-the-fly as users are typing. Fortunately, Excel has enough customization tools to add such a...
How to close all workbooks in Excel with VBA

How to close all workbooks in Excel with VBA

by | Feb 21, 2022 | Excel Tips & Tricks

If you are working with multiple Excel files at once, you often find yourself dealing with warning messages when trying to close them. Although it is a good thing to be warned about saving to not lose changes in a workbook, it may become annoying quickly. Thanks to...
How to spell check using VBA in Excel

How to spell check using VBA in Excel

by | Sep 13, 2021 | Excel Tips & Tricks

Excel can spell check, but it's not as capable as the spell check in Word, nor is it automatic. Using VBA, you can automate the spell-checking process in your workbooks. In this guide, we’re going to show you how to spell check using VBA in Excel. Download Workbook...
How to display File Open dialog in VBA

How to display File Open dialog in VBA

by | Jun 22, 2021 | Excel Tips & Tricks

Excel VBA allows you to open a workbook directly - all you need is the full path of the file, including the file name. However, locating and supplying the file path each time may can be tedious when working with multiple files. In this guide, we’re going to show you...