×

VBA Coding Basics

How To Add Comments/Notes To Your VBA Code

How To Add Comments/Notes To Your VBA Code

How To Insert A VBA Comment/Note Microsoft's VBA coding language allows you to create non-executable lines of code for commenting...

Learn VBA Macro Coding Basics In Excel [2024 Guide]

Learn VBA Macro Coding Basics In Excel [2024 Guide]

No Coding Experience? No Problem! First I want to congratulate you because if you are taking the time to read...

How To Use A VBA Macro You Found On The Internet

How To Use A VBA Macro You Found On The Internet

You Finally Found It! Yes, I’ve been there! You’ve spent days scouring the internet to find a solution to a...

How To Automatically Run Excel VBA Macros Daily

How To Automatically Run Excel VBA Macros Daily

I’m currently working on a consulting project where a VBA macro within an Excel file needs to run every morning...

My Personal Macro Workbook Disappeared! How To Get It Back

My Personal Macro Workbook Disappeared! How To Get It Back

Where Did It Go!? Man-oh-man did this freak me out the first time this happened! One day, I opened up...

How To Stop Screen Flickering While Running VBA Macros in Excel

How To Stop Screen Flickering While Running VBA Macros in Excel

You may come across times where you write a beautiful Excel macro with lots of nifty VBA code and when...

Determine What Is Currently Selected With VBA

Determine What Is Currently Selected With VBA

Why Is This Important? When you are writing VBA macros that rely on a user’s selection, you want to make...

A VBA For Loop In Reverse Order

A VBA For Loop In Reverse Order

What This VBA Code Does Looping is a great coding technique to condense the amount of VBA lines you write....

VBA Guide To Referencing Worksheet Tabs

VBA Guide To Referencing Worksheet Tabs

Referencing Worksheets in Excel When you are working with VBA inside Excel, it is more than likely that you will...

How Pros Dynamically Resize & Fill VBA Array Variables (Multiple Scenarios)

How Pros Dynamically Resize & Fill VBA Array Variables (Multiple Scenarios)

What Are Arrays? Arrays are a variant type variable that you can use in VBA coding to store a list...

How To Repeat Tasks With Your VBA Code by Looping

How To Repeat Tasks With Your VBA Code by Looping

Your Complete Looping Guide Looping is extremely important when coding because it can shorten up the length of your code...

Best Way To Improve VBA Macro Performance (Prevent Slow Code!)

Best Way To Improve VBA Macro Performance (Prevent Slow Code!)

This topic has been written about in detail many times, but those who are new to VBA or even computer...

VBA Code To Calculate How Long Your Macro Takes To Run

VBA Code To Calculate How Long Your Macro Takes To Run

What This VBA Code Does There are various scenarios where you may want to calculate the time it takes for...

Activate Object Library References in Visual Basic Editor

Activate Object Library References in Visual Basic Editor

What This VBA Code Does This bit of code will allow you to turn on specific VBA reference libraries (I...

Debugging VBA Code: Adding Breakpoints

Debugging VBA Code: Adding Breakpoints

Sometimes it pays to stay in bed on Monday, rather than spending the rest of the week debugging Monday’s code....

Display Object Library Reference GUID Information

Display Object Library Reference GUID Information

What This VBA Code Does This VBA code will display the GUID information for all activated references in the VBA...

How To Determine Your Variable Type

How To Determine Your Variable Type

What This VBA Code Does Are you ever unsure of what kind of variable you need to declare? You can...

Explaining Private vs. Public Declarations

Explaining Private vs. Public Declarations

So What’s This Private and Public Stuff Mean? The VBA terms Private and Public declare the access allowed to the...

Teaching Excel How To Speak PowerPoint

Teaching Excel How To Speak PowerPoint

Teaching Excel How To Speak PowerPoint In order to control PowerPoint (or any other program) from inside Excel's Visual Basic...

How To Create A Personal Macro File

How To Create A Personal Macro File

What Is A Personal Macro File? A Personal Macro file is a file you can create to store VBA code...

What Does Dim Mean When Coding VBA Macros?

What Does Dim Mean When Coding VBA Macros?

What Is Dim And Why Do People Use It? Dim is short for the word Dimension and it allows you...

Turn Off Syntax/Compile Error Alerts in Visual Basic Editor

Turn Off Syntax/Compile Error Alerts in Visual Basic Editor

Writing VBA Code Can’t Be This Annoying, Can It? When I first started coding in the Visual Basic Editor (VBE)...