Welcome to the exciting world of worksheet events in Excel! If you're looking to take your skills with Microsoft Excel to the next level, you'll definitely want to learn more about how to use worksheet events with Visual Basic for Applications (VBA). But what exactly is a worksheet event? Essentially, it's something that happens in […]

I. Introduction A. What is VBA? VBA stands for Visual Basic for Applications and is a programming language used to automate tasks in Microsoft Office applications such as Excel, Word, and PowerPoint. It is based on the Visual Basic programming language and can be used to create macros, automate processes, and customize the user interface. […]

Part 1/2 Learn how to add a powerful ComboBox dropdown menu to your sheet that can be moved anywhere you need and resized dynamically! Allows typing or selecting. Ready to become an Excel Ninja? 👇 Part 2/2 Learn how to take your ComboBox and link it's value to another cell, even on another sheet. Yep, […]

Did you know in Excel, you can now instantly get a unique list of items from a larger data set with almost zero work? This formula (available in Excel 2021, Microsoft 365 for PC/Mac, Excel Online) makes the magic work for you: =UNIQUE(array,[by_col], [exactly_once]) See below: Here's how it works: Type =UNIQUE( Select a group […]

Avoid typing the same cell address(es) multiple times in a formula. Use familiar nicknames instead. What is a named range? Named ranges are a great way to make your formulas more readable and easier to reference. They're also great for using common values without having to type them every time. Named ranges make it easy […]

Are you tired of manually emailing information from your spreadsheet? Well, you're in luck! In this tutorial, I'll show you how to use Pabbly to send automatic emails from Excel, so you can spend less time on administrative tasks and more time doing what you actually enjoy - working on your spreadsheet! Pabbly is a […]

Are you looking for a way to translate all your data into another language? If so, you're in luck! This blog will teach you how to use Microsoft Translator to do just that - for free! With Microsoft Translator, you can easily translate cells from one language to another. This can be useful if you […]

Introduction Sending emails from Excel can be a challenge, especially if you don't know how to use VBA. For example, you may have a list of customers that you want to send an email to in order to send them some information about their account. Fortunately for those who need to send emails in Excel, […]

Worksheet Events are amazing tools that can bring life and automation into your Excel Programs, such as triggering a macro when you click to a specific sheet, select a certain cell or even make changes to specific areas of a worksheet. Sometimes, you'll find that your worksheet event isn't firing and if you're like me, […]

One of the most important parts (if not the most important part) about purchasing a new home or finding a new place to live is the location and how close it is to the people and places that are most important to you. I have seen a lot of home I would have loved to […]