VBA Loops – For, For Each, Do While and Do Until Loops

Loops are used in VBA for repeating a set of statements multiple times. Loops form an essential part of any programming language, and VBA is no exception. There are five different types of loops that can be used in VBA. These are as follows: For Loop For Each Loop Do While Loop Do Until Loop Wend Loop (obsolete)In this post, I … [Read more...]

How to Insert a Checkbox in Excel (In 5 Easy Steps)

Inserting a checkbox in Excel is an easy task. The checkbox control is available in the Excel developer tools option. Checkbox and other controls like dropdowns can be quite helpful while designing forms in Excel.These controls prevent users from entering some unwanted data in your forms, and hence they are preferred.In this post, we will … [Read more...]

Excel IF Statement – How to Use

IF statement is undoubtedly one of the most important formulas in excel. In general, the IF statement gives the desired intelligence to a program so that it can make decisions based on given criteria and, most importantly, decide the program flow.In Microsoft Excel terminology, IF statement is also called as "Excel IF-Then statement" or "Excel … [Read more...]

Round Function In Excel – The Complete Guide

Microsoft Excel provides multiple formulas to round numbers. We have formulas like - ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD, and they all can be used to round numbers in excel.Rounding is the process of removing the least significant digits from a number so that we are left with a simpler value that is … [Read more...]

How to Insert Multiple Rows in Excel

In the last few decades, Microsoft has grown by leaps and bounds and so are its fabulous products. Microsoft Excel is one such product that has grown immensely. It has wonderful features and options to make your tasks easier. But one feature that it lacks is the ability to insert multiple rows. The default insert option that Excel has allows you to … [Read more...]

VBA Wait and Sleep Functions – Explained

Wait and Sleep functionality in programs is required to hold or pause the program execution for a specified time. These methods suspend all the activities of Microsoft Excel and sometimes may also prevent you from performing other operations on it until the pause is in effect.However, your computer can simultaneously process other background … [Read more...]

How to Spell Check In Excel

Microsoft Excel doesn't have advanced capabilities like grammar checking and correction but still, it offers the basic spell checking functionality. This built-in spell checker in Microsoft Excel can help you to double-check your excel sheets before you send them across to someone else.One thing that I would like to point out is that the … [Read more...]

Excel SUMIF and SUMIFS – Explained

As the name suggests SUMIF and SUMIFS formulae are formed by combining SUM and IF functions. In simple English, this implies that these functions can add items or cells that fulfill a particular criterion. Let’s understand it in detail.Understanding SUMIF and SUMIFS FunctionsYou know SUM function has the capability to add items, and SUMIF … [Read more...]