GET ULTIMATE EXCEL

Recent Posts

Check out the latest articles on making your life more fun with Excel VBA!
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
Highlight Userform Textbox in Excel VBA, Highlight All Text On Mouse Click, Button or Userform Open
Read More
Increase TextBox Date Using Up and Down Arrow Keys In Excel VBA

We had a question today regarding how to increase or decrease the date field in this Excel VBA user form. The first thing we had to do was create a user form and insert a Text Box. When we double-click on this text box, the default event is the change event, which will trigger every […]

Read More
How To Prompt For A File In Excel VBA

If you need to Prompt to open a file in Excel VBA, check out the below code snippet. Please leave us a comment below if you have questions or comments and share this page if you think it can help others! You can now manipulate the other workbook, because we told Excel that the other […]

Read More
Enter Textbox Date In Excel Without The Slash – Type Only The Numbers

Sometimes you might have a client or you yourself may have the need for a date text box where the user wants to type in only the numerals for a date, and none of the slashes. The first thing we need to do is create a user form with a single text box in it. […]

Read More
Changing A Cell’s Value In Excel VBA (Range Object Method)

[et_pb_section bb_built=”1″ next_background_color=”#000000″][et_pb_row][et_pb_column type=”4_4″][et_pb_text _builder_version=”3.0.105″ background_layout=”light”] One of the most foundational things to learn about when using Excel VBA is how to change a cell value, so that you deal with with this blog post. On the most basic level, all you have to do is open up the Visual Basic editor in Excel by […]

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