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 […]
How To Use Selenium with Excel in 4 Simple StepsFrank Gunseor decided to send us a nice video describing how useful he finds using Selenium directly from Microsoft Excel.
How To Get Better Looking Buttons in ExcelWhen 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 […]
Extra Sheets In Excel VBA - Corrupt Excel Workbook HelpIf 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 […]
Create Sheets For Each User From Column ASometimes 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 […]
How To Add A Date Picker Calendar in Excel VBADate 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 […]
Forget Option Explicit, Excel VBA Declaring Variables: 6 Reasons Why You No Longer Need ItTo 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 […]
Highlight Userform Textbox in Excel VBA, Highlight All Text On Mouse Click, Button or Userform OpenRead More
Increase TextBox Date Using Up and Down Arrow Keys In Excel VBAWe 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 […]
