Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

Recent Posts

Check out the latest articles on making your life more fun with Excel VBA!
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
How To Declare Unknown Objects And Variables In Excel VBA?

I get this question now and then.. How am I supposed to declare these things in order to get Intellisense or just because I want to declare everything? My Students Firstly, I would say, “Remove Option Explicit” from the top of your macros as you don’t generally need this handicap, but some would argue that […]

Read More
How To Use Selenium with Excel in 4 Simple Steps

Frank Gunseor decided to send us a nice video describing how useful he finds using Selenium directly from Microsoft Excel.

Read More

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!
LEARN MORE
Copyright © 2022 ExcelVbaIsFun
X

Forgot Password?

Join Us

0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    BLACK FRIDAY

    IS HERE!

    Huge Black Friday savings are here! But hurry, these deals might not last. Get it before the storm is over!

    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram