GET ULTIMATE EXCEL

Recent Posts

Check out the latest articles on making your life more fun with Excel VBA!
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
How To Get Better Looking Buttons in Excel

When you buy something using the retail links in our pages, we may earn a small commission. ExcelVbaIsFun does not accept money for editorial product or software reviews. Read more about our policy. One of the most common things in applications is the humble button. In fact, the modern individual is so used to clicking […]

Read More
Extra Sheets In Excel VBA – Corrupt Excel Workbook Help

If you’ve ever encountered a corrupt Excel workbook, you’ve probably tried lots of things already, including possibly tearing your hair out. In this particular scenario, we have lots of extra sheets that show up in the Visual Basic Editor. This is not great. …and it may have an extra ThisWorkbook object too! It looks like […]

Read More
Create Sheets For Each User From Column A

Sometimes in Excel, we need to automate simple tasks, like to create sheets automatically for each item in a range. If you just had a few worksheet tabs that needed to be created, it wouldn’t be a big deal, but what if you had to create 100 different worksheet tabs?! Enter the magical world of […]

Read More
How To Add A Date Picker Calendar in Excel VBA

Date Picker Calendar in Excel VBA Oftentimes, users want to click a button and select a date. This is no different for Excel developers. Check out this ActiveX control by Microsoft that allows users to do just that. It’s a little old school looking, but actually has quite a nice feel to it. Start by […]

Read More
Forget Option Explicit, Excel VBA Declaring Variables: 6 Reasons Why You No Longer Need It

To Dim or Not To Dim… As an Excel Developer, Instructor, Vlogger and Public Speaker on Excel VBA, I get asked a lot about the importance of declaring variables with Dim and why I don’t always use this in practice. There are several reasons why I don’t declare every little thing, and I will happily […]

Read More
Student Saves 5+ Hours With Excel VBA Web Automation Course?
Read More
1 2 3

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
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram