How To Insert A VBA Comment/Note Microsoft's VBA coding language allows you to create non-executable lines of code for commenting...
No Coding Experience? No Problem! First I want to congratulate you because if you are taking the time to read...
You Finally Found It! Yes, I’ve been there! You’ve spent days scouring the internet to find a solution to a...
I’m currently working on a consulting project where a VBA macro within an Excel file needs to run every morning...
Where Did It Go!? Man-oh-man did this freak me out the first time this happened! One day, I opened up...
You may come across times where you write a beautiful Excel macro with lots of nifty VBA code and when...
Why Is This Important? When you are writing VBA macros that rely on a user’s selection, you want to make...
What This VBA Code Does Looping is a great coding technique to condense the amount of VBA lines you write....
Referencing Worksheets in Excel When you are working with VBA inside Excel, it is more than likely that you will...
What Are Arrays? Arrays are a variant type variable that you can use in VBA coding to store a list...
Your Complete Looping Guide Looping is extremely important when coding because it can shorten up the length of your code...
This topic has been written about in detail many times, but those who are new to VBA or even computer...
What This VBA Code Does There are various scenarios where you may want to calculate the time it takes for...
What This VBA Code Does This bit of code will allow you to turn on specific VBA reference libraries (I...
Sometimes it pays to stay in bed on Monday, rather than spending the rest of the week debugging Monday’s code....
What This VBA Code Does This VBA code will display the GUID information for all activated references in the VBA...
What This VBA Code Does Are you ever unsure of what kind of variable you need to declare? You can...
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 In order to control PowerPoint (or any other program) from inside Excel's Visual Basic...
What Is A Personal Macro File? A Personal Macro file is a file you can create to store VBA code...
What Is Dim And Why Do People Use It? Dim is short for the word Dimension and it allows you...
Writing VBA Code Can’t Be This Annoying, Can It? When I first started coding in the Visual Basic Editor (VBE)...
[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!