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...
In this guide, we’re going to show you how to get division remainders in Excel using the MOD function. This function is frequently used in mathematical and logical calculations. You can create distributions, create a switch mechanism, and more with the MOD function....
A step chart is a type of line chart that displays the changes over time in data. Unlike a regular line chart, step charts connect data points with vertical and horizontal lines. Although Excel does not have step chart support by default, you can follow our guide to...
Numeric values are defined by data types like integer or byte. These data types are used for optimizing the processing and memory allocation in Excel. In this guide, we’re going to show you how to convert string into number in Excel VBA. Download Workbook Data types...
The Scenario Manager can keep a set of input values for specific cells, and allows you to switch between them.This can be very helpful if you have a lot of input combinations to test against a model. In this guide, we’re going to show you how to use Scenario Manager...
A spin button is a control that allows users to select a numeric value from a specific range. These buttons consists of two arrow and look like scroll bars without the scroll. In this guide, we’re going to show you how to insert a spin button in Excel. Download...
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...
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....
A slider is a control that allows selecting a numeric value from a certain range. In this guide, we’re going to show you how to insert a slider in Excel. Download Workbook Developer Tab and Scroll Bar command The command for adding option buttons can be found under...
