How to Work with VBA Ranges in Excel: Full Guide When you’re working in VBA, you’ll have to tell Excel which cells you want a particular command to apply to. To do that, you’ll use the range object. A range is simply a cell or collection of cells that you tell Excel to pay [...]
How to use VLOOKUP in Excel VBA: Step-by-Step Visual Basic for Applications (VBA) has many built-in functions that help you work with spreadsheet data. But "normal" Excel is the undisputed king when it comes to useful functions. Fortunately, you can use worksheet functions to take advantage of that power when you’re writing macros [...]
How to Use Message Boxes in Excel: Step-by-Step Guide (MsgBox) In this article, we are going to show you how to create a message box in Excel. Also called an Excel message box (VBA style). If you do not have any experience with VBA, do not worry (make sure to check this out [...]
How to Open & Use the VBA Editor in Excel (Visual Basic) Excel’s Visual Basic for Applications (VBA) editor is a very powerful tool. It lets you write and edit custom scripts that automate actions in Excel. In fact, when you record a macro it is stored in VBA code in the VBA editor. [...]
How to Add the Developer Tab in Excel: Step-by-Step If you’re a power user of Excel, the Developer tab is a great addition to the Ribbon. It lets you access useful features that are otherwise hidden away. But you have to get to the Developer Tab to show first! Because for some reason, [...]
VBA Data Types: How to Declare (Dim) and Set VBA Variables A variable in programming is like a variable in math: it stands in the place of a value, and that value can change. This is extremely useful when writing VBA code. Declaring variables means telling Excel what data type will go into [...]
How to Use "For Loops" in Excel VBA: Step-by-Step In programming, loops allow you to run the same code multiple times. It’s simple, but it’s one of the most powerful things you can do with VBA. (And it saves you a huge amount of typing.) In this guide, I show you how to [...]
How to Insert Excel Data Into Word (Tables, Files, Spreadsheets) Microsoft Word is great for working on documents—but not so great with tables of data. If you want to put a table into a Microsoft Word document, you can work with Word’s built-in table tools, or you can insert data directly from Excel. [...]
How to Use the Excel Functions ISNUMBER, ISTEXT and ISNONTEXT IS functions are really fun to work with. They'll return Boolean values (TRUE or FALSE) but can prove super useful when used the right way. The ISNUMBER and ISTEXT function belong to the same IS family of Excel. What are these functions used [...]
How to Calculate Standard Deviation in Excel Step-by-Step Talking about statistics, the concept of standard deviation and mean go hand in hand 🤝 Mean only gives you the average figure for a dataset. But how truly does that figure represent the individual numbers of that dataset? Standard deviation will tell you that. Standard [...]