How to extract date from string in Excel

How to extract date from string in Excel

In this guide, we’re going to show you how to extract date from string in Excel by using formulas and VBA. Download Macro-Free Workbook Download Workbook Note that, there isn't a single formula or approach that can handle all scenarios. Extracting dates from strings...
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 show a message on Status Bar in Excel

How to show a message on Status Bar in Excel

In this guide, we’re going to show you how to show a message on Status Bar in Excel. Download Workbook What is Status Bar? The status bar is the bottom section of the application window (like in some other Windows applications). It displays additional information...
How to show a closing message in Excel

How to show a closing message in Excel

In this guide, we’re going to show you how to show a closing message in Excel by using macros. Download Workbook ThisWorkbook object and Workbook_BeforeClose Event If you want to trigger any action at the before closing of your workbook, you must add your code under...
How to show a welcome message in Excel

How to show a welcome message in Excel

In this guide, we’re going to show you how to show a welcome message in Excel by using macros. Download Workbook ThisWorkbook object and Workbook_Open Event If you want to trigger any action at the startup of your workbook, you must add your code under Workbook_Open....
How to insert a toggle in Excel

How to insert a toggle in Excel

A toggle button allows selecting from two options: They are like on/off switches or Play/Pause buttons. In this guide, we’re going to show you how to insert a toggle in Excel. Download Workbook Excel supports toggle buttons as development tools.You can assign them...