Have Questions? 
Excel Ninja Pro
All Access

Recent Posts

Check out the latest articles on making your life more fun with Excel VBA!
Excel Worksheet VBA Events: A Step-by-Step Guide

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 […]

Read More
How To Use VBA On Locked Excel Sheets

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. […]

Read More
Excel ComboBox Intro and How To Used a LinkedCell

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, […]

Read More
How To Get A Unique List in Excel Instantly

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 […]

Read More
How To Improve Your Excel Formulas With Named Ranges

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 […]

Read More
How to Use Pabbly to Send Automatic Email from Excel

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 […]

Read More
Translate Your Excel Data to a Different Language for Free with Microsoft Translator

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 […]

Read More
5 Ways To Send Emails In Excel

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, […]

Read More
10 Reasons Your Worksheet Event Isn't Firing (And How To Fix It)

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, […]

Read More
Find Google Distance and Time Between Multiple Locations - Google Apps Script Tutorial

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 […]

Read More
1 2 3 4

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
Copyright © 2024 ExcelVbaIsFun

Forgot Password?

Join Us

    Your Cart
    Your cart is emptyReturn to Shop
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram