How to filter as you type with VBA in Excel

How to filter as you type with VBA in Excel

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

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

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

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

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...