×

VBA

Get Your Manager to Pay For Your Excel Training (Amazing Email Templates)

Get Your Manager to Pay For Your Excel Training (Amazing Email Templates)

Why Request Excel Funding For Yourself? It has always amazed me how little formal education employees have on the software...

VBA Function To Validate Range Address

VBA Function To Validate Range Address

You Need To Check Your Cell Address Input A common task when using VBA with Excel is to validate cell...

VBA Code To Find Last Row Or Last Column (Best Way)

VBA Code To Find Last Row Or Last Column (Best Way)

Dynamic VBA Code With Last Row/Column Finding the Last Row or Last Column within your VBA code is key to...

VBA Code To Highlight All Instances of Word/Phrase Within A Range

VBA Code To Highlight All Instances of Word/Phrase Within A Range

What This VBA Code Does Have you ever had to search through a large Excel spreadsheet to find specific text?...

Get URL Webpage Title With VBA Function

Get URL Webpage Title With VBA Function

What This VBA Code Does Manually copying and pasting website titles can be tedious, error-prone, and time-consuming. However, by writing...

VBA Function To Test For Internet Connection

VBA Function To Test For Internet Connection

What This VBA Code Does Sometimes you might be writing macro code that requires reaching out to cloud-based files or...

Add Line Breaks In Screentips & SuperTips (Ribbon XML)

Add Line Breaks In Screentips & SuperTips (Ribbon XML)

Parts Of A Ribbon Button’s Tool Tip Programatically, there are two parts to a button’s tool tip box that appears...

VBA Coding For Shapes (The Complete Guide)

VBA Coding For Shapes (The Complete Guide)

VBA Coding With Shape Objects In this comprehensive guide, you will be learning all the ways you can create and...

Deleting Rows With VBA By Looping (Correctly)

Deleting Rows With VBA By Looping (Correctly)

Deleting Rows With For Each Loop Misses Rows When I first attempted to delete rows using VBA code I thought...

Remove Chart Data Labels With Specific Value

Remove Chart Data Labels With Specific Value

There may be times when you would like to de-clutter your data labels so that smaller or zero values are...

How To Create MSI Auto-Installers For VBA Add-ins

How To Create MSI Auto-Installers For VBA Add-ins

I’ve had quite a few IT administrators request that I provide an MSI Installer file (often referred to as a...

Convert HEX To RGB Color Codes (VBA Macro)

Convert HEX To RGB Color Codes (VBA Macro)

What This VBA Code Does If you need to convert Hex color codes into the RGB format, the below macro...

Using XLOOKUP Function’s Power In VBA Macro Code

Using XLOOKUP Function’s Power In VBA Macro Code

What This VBA Code Does The following VBA code will show you how to utilize the power of Excel’s XLOOKUP...

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...

Copy Each Excel Tab To Individual File or PDF (In Seconds!)

Copy Each Excel Tab To Individual File or PDF (In Seconds!)

Splitting Up Your Excel Sheets If you’ve come across this article, chances are you are looking for a solution that...

How To Change Sheet Tab Color With VBA

How To Change Sheet Tab Color With VBA

What This VBA Code Does There may be times when you need to incorporate coloring your worksheet tabs in your...

How To Use VBA Code With Oracle’s Smart View Add-in

How To Use VBA Code With Oracle’s Smart View Add-in

What Is The Oracle Smart View Add-in? The Smart View Excel Add-in is a free Oracle tool that allows you...

Prevent SaveAs Prompt When Overriding File With VBA

Prevent SaveAs Prompt When Overriding File With VBA

What This VBA Code Does You may find yourself needing to override a current Excel file with changes using VBA...

Inserting Rows Or Columns With VBA Code

Inserting Rows Or Columns With VBA Code

What This VBA Code Does The following VBA examples will show you how to insert a row or column based...

Learn VBA Macro Coding Basics In Excel [2023 Guide]

Learn VBA Macro Coding Basics In Excel [2023 Guide]

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

Turn Off AutoFit Column Width For All Pivot Tables

Turn Off AutoFit Column Width For All Pivot Tables

What This VBA Code Does If you live dangerously and have multiple Pivot Tables sporadically on a single sheet (I’ve...

Loop Through Every PivotTable With VBA

Loop Through Every PivotTable With VBA

What This VBA Code Does There may be times when you need to carry out a VBA automation on all...

VBA To Determine If Duplicates Exist In Range

VBA To Determine If Duplicates Exist In Range

What This VBA Code Does There may be instances where you need to ensure there are no duplicate values within...

VBA To Determine If Number Is Odd Or Even

VBA To Determine If Number Is Odd Or Even

What This VBA Code Does You may have found yourself in a situation where you need to determine if a...

Allow User-Specific Login Credentials To Be Pulled With Excel VBA

Allow User-Specific Login Credentials To Be Pulled With Excel VBA

There are a ton of great data programs out there that integrate very nicely with Excel. The problem I see...

VBA Code To Select A Folder Path

VBA Code To Select A Folder Path

What This VBA Code Does This VBA code will show you how to allow your user to select a folder...

VBA Code To Hide All Shapes Within A Chart Object

VBA Code To Hide All Shapes Within A Chart Object

What This VBA Code Does If you are trying to hide all shapes in a worksheet, yet some of those...

VBA to Populate Userform Combobox from Excel Table

VBA to Populate Userform Combobox from Excel Table

What This VBA Code Does The below code will show you how to utilize an Excel Table Object to populate...

Refresh Ribbon UI  In Your Custom Excel Add-in

Refresh Ribbon UI In Your Custom Excel Add-in

What This VBA Code Does There may be times when you need to refresh the user interface (UI) of your...

Clean Up Superscript & Subscript Text in Excel Data

Clean Up Superscript & Subscript Text in Excel Data

Dealing With SuperScripts/Subscripts Sometimes you receive data or copy data that has superscripts or subscripts that you really don’t want...

VBA To Determine If Cell Has No Fill Color

VBA To Determine If Cell Has No Fill Color

What This VBA Code Does The following line of VBA code will allow you to determine if a spreadsheet cell...

VBA To Adjust Freeze Panes In Excel

VBA To Adjust Freeze Panes In Excel

What This VBA Code Does I hate changing the Freeze Pane location because it takes two steps instead of one....

Copy/Paste A Dynamic Formula Spill Range With VBA

Copy/Paste A Dynamic Formula Spill Range With VBA

What This VBA Code Does There are a plethora of new Dynamic Array functions being released in Excel that produce...

Refresh All Data Connections/Queries In Excel

Refresh All Data Connections/Queries In Excel

With the release of integrated stock pricing in Microsoft Excel, it was unfortunate there wasn’t any sort of setting that...

VBA Code To Save As Picture in Excel

VBA Code To Save As Picture in Excel

Not As Easy As You’d Think… One would think that saving something as a picture file (png, jpg, etc…) inside...

Alphabetically Sort Cell Range Values With VBA Code

Alphabetically Sort Cell Range Values With VBA Code

What This VBA Code Does You may run into instances where you need to alphabetically sort your cell data (typically...

Resolve Extremely Slow Pasting Into Excel Tables

Resolve Extremely Slow Pasting Into Excel Tables

Stop The Madness! One thing that has always annoyed me with Excel Tables, is how slow it can be to...

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...

VBA To Add A Prefix to Selected Cells

VBA To Add A Prefix to Selected Cells

What This VBA Code Does In my day job, I often have to add a prefix to thousands of ID...

VBA To Show Detail For A SUMIFS Function

VBA To Show Detail For A SUMIFS Function

What This VBA Code Does I had a colleague at work come to me with some code he had found...

Swap Two Selected Cell Ranges In Excel

Swap Two Selected Cell Ranges In Excel

What This VBA Code Does Often times when I am preparing spreadsheet reports, I find myself needing to perform minor...

Don’t Show Update External Links Dialog While Opening Files With VBA

Don’t Show Update External Links Dialog While Opening Files With VBA

What This VBA Code Does You are most likely reading this article because you thought turning off ScreenUpdating and DisplayAlerts...

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...

How To Build A Modern-Looking VBA Userform

How To Build A Modern-Looking VBA Userform

The Need For A Modern UI Let’s face it, VBA Userforms haven’t had much love from Microsoft over the past...

VBA To Allow User To Select A Range With An InputBox

VBA To Allow User To Select A Range With An InputBox

I’ve run into a few times where I felt the user experience would be more streamlined if I gave them...

VBA To Only Change Selection’s Border Color

VBA To Only Change Selection’s Border Color

What This VBA Code Does Let’s face it, it’s a real pain to change the colors of borders….especially if they...

Remove Page Breaks From All Open Spreadsheets

Remove Page Breaks From All Open Spreadsheets

What This VBA Code Does Ever get those annoying dotted lines on all your spreadsheets after viewing a print preview?...

VBA To Insert Zeroes Into Blank Cells

VBA To Insert Zeroes Into Blank Cells

What This VBA Code Does If you do any data loading to databases and prepare/clean that data in Excel, you...

VBA To Remove/Delete Superscripts From Excel Cell Text

VBA To Remove/Delete Superscripts From Excel Cell Text

What This VBA Code Does I have run into a couple of instances recently where I needed to clean up...

The VBA Guide For Using Userform ListBox Controls

The VBA Guide For Using Userform ListBox Controls

What Are ListBox Controls? ListBoxes are a great way to manage tables within your userform. I have used them in...

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...

Use VBA To Determine Hex Color Code

Use VBA To Determine Hex Color Code

What This VBA Code Does I ran into an issue where I needed some of my brand colors to be...

VBA To Find All Cells That Are Blank/Empty

VBA To Find All Cells That Are Blank/Empty

What This VBA Code Does I’ve had numerous instances over the years when I have needed to target blank or...

How To Prevent The Excel Error Message For A Missing Add-in

How To Prevent The Excel Error Message For A Missing Add-in

I’ve run into this issue numerous times and I just figured out how to prevent the dreaded error message from...

Password Protecting/Unprotecting A List of Excel Sheet Names

Password Protecting/Unprotecting A List of Excel Sheet Names

What This VBA Code Does Today, a colleague of mine described to me a situation (aka annoyance) he was trying...

VBA To Insert A Date Into A Cell

VBA To Insert A Date Into A Cell

What This VBA Code Does The following VBA macro code will show you a couple of different ways to insert...

VBA Code To Select Next & Previous Spreadsheet Tabs

VBA Code To Select Next & Previous Spreadsheet Tabs

What This VBA Code Does The following VBA macro code will allow you to create navigation arrow buttons that will...

VBA Function To Determine If A Worksheet Exists In A Workbook

VBA Function To Determine If A Worksheet Exists In A Workbook

What This VBA Code Does The following VBA macro code provides a function that tests if a worksheet exists in...

VBA Code To Validate A File Path

VBA Code To Validate A File Path

What This VBA Code Does This VBA function will accept a file path text string and confirm if the file...

Adding A Logo or Image To A Spreadsheet Header/Footer

Adding A Logo or Image To A Spreadsheet Header/Footer

What This VBA Code Does If you are using Headers or Footers for your spreadsheets, the chances are you're going...

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...

Save Your PowerPoint Slides As Images

Save Your PowerPoint Slides As Images

There may be occasions when you will want to export/save a particular PowerPoint slide(s) as an image file. A real...

How To Determine Hex Color Codes For VBA Userforms

How To Determine Hex Color Codes For VBA Userforms

What This VBA Code Does If you have ever formatted VBA userforms, you’ve most likely noticed that the color codes...

Populate A PowerPoint Quiz From Excel With VBA

Populate A PowerPoint Quiz From Excel With VBA

A couple months ago I received an email from Titus who was looking for a way to easily populate and...

VBA To Load Your Own Recent Colors To PowerPoint Palette

VBA To Load Your Own Recent Colors To PowerPoint Palette

What This VBA Code Does Do you have certain colors outside of the Microsoft theme color presets that you like...

VBA Function To Determine If A Shape Has A Gradient Effect

VBA Function To Determine If A Shape Has A Gradient Effect

What This VBA Code Does I recently needed to create a VBA function that tests if a particular shape object...

VBA To Delete All Shapes On A Spreadsheet

VBA To Delete All Shapes On A Spreadsheet

What This VBA Code Does The following VBA code will provide you with a way to delete all shapes from...

How To Keep Track Of Your Shapes Created With VBA Code

How To Keep Track Of Your Shapes Created With VBA Code

Lately, I have been writing a lot of VBA code dealing with the creation of shapes and managing them. I...

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 To Handle White Cell Fill Colors

VBA To Handle White Cell Fill Colors

What This VBA Code Does If you are a formatting nut like me, you will most likely appreciate an issue...

VBA Code To Insert An Image Into A Cell Comment

VBA Code To Insert An Image Into A Cell Comment

What This VBA Code Does Using screenshots inside a cell's comment box is a neat little trick I like to...

VBA To Change Text Case Within A Selection Of Cells

VBA To Change Text Case Within A Selection Of Cells

What This VBA Code Does The following VBA macro code is something I use all the time to manipulate the...

PowerPoint VBA Remove All Animation Effects

PowerPoint VBA Remove All Animation Effects

What This VBA Code Does This VBA macro code will loop through all slides within the ActivePresentation and remove any...

VBA Set Shape Variable To Selected Shape

VBA Set Shape Variable To Selected Shape

What This VBA Code Does The following code will show you how to take the currently selected shape in an...

Determine Height & Width of Selected Cell Range With Excel VBA

Determine Height & Width of Selected Cell Range With Excel VBA

What This VBA Code Does When creating dashboards you will want to try your best to keep your spacing even...

Excel VBA To Add Custom Colors To Recent Colors Section of Palette

Excel VBA To Add Custom Colors To Recent Colors Section of Palette

A Little Background This post shows how you can use VBA code to add specific colors (outside your color theme)...

Prevent Excel From Automatically Formatting Data As Dates When Pasted

Prevent Excel From Automatically Formatting Data As Dates When Pasted

What This VBA Code Does Lars-Erik reached out to me via Facebook with an interesting code concept that would prevent...

PowerPoint VBA Function To Test If Object Can Contain Text

PowerPoint VBA Function To Test If Object Can Contain Text

What This VBA Code Does In PowerPoint, it can be very useful to know if the object you are working...

Group All Shapes Within A Selection Of Cells

Group All Shapes Within A Selection Of Cells

What This VBA Code Does This VBA code is a nifty little I created to solve the hassle of selecting...

Generate A String Of Random Characters With VBA Code

Generate A String Of Random Characters With VBA Code

What This VBA Code Does This VBA macro function will allow you to generate a string of characters at random...

VBA Code To Convert Column Number to Letter Or Letter To Number

VBA Code To Convert Column Number to Letter Or Letter To Number

What This VBA Code Does In this article, I'm going to show you how to easily convert a cell column...

VBA Function To Validate (Test) A Given PowerPoint File Name

VBA Function To Validate (Test) A Given PowerPoint File Name

What This VBA Macro Code Does When you ask your users to supply a file name during your VBA automation,...

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...

Allow Groups to Expand/Collapse While Spreadsheet Is Password Protected

Allow Groups to Expand/Collapse While Spreadsheet Is Password Protected

What This VBA Code Does Unfortunately when password protecting your worksheets, there is no option to check that will enable...

VBA To Convert Named Ranges: Workbook To Worksheet Scope

VBA To Convert Named Ranges: Workbook To Worksheet Scope

What This VBA Code Does I had a project today that required me to change the scope of all my...

VBA Function To Determine If Any Worksheet Tabs Are Protected

VBA Function To Determine If Any Worksheet Tabs Are Protected

What This VBA Code Does Excel does this annoying thing where it prevents you from creating custom Table or Slicer...

How To Change The Mouse Cursor Icon In Your VBA Userform

How To Change The Mouse Cursor Icon In Your VBA Userform

Why Change Your Userform's Cursor? There may be certain instances where it makes sense to change the look of the...

How To Set Focus To The Excel Window After Showing A Userform

How To Set Focus To The Excel Window After Showing A Userform

What This VBA Code Does There may be situations when you are using Excel Userforms where you would like the...

Use VBA To Automatically Adjust Your Charts Y-Axis Min and Max Values

Use VBA To Automatically Adjust Your Charts Y-Axis Min and Max Values

Why Manually Adjust Your Y-Axis? By default, Excel will automatically decide the minimum and maximum values of your vertical (Y)...

VBA To Find The Last Cell With A Specific Fill Color

VBA To Find The Last Cell With A Specific Fill Color

QUESTION How can a find the last cell on a spreadsheet based on a given color? SOLUTION This VBA macro...

Dynamically Populating VBA Array Variables To Store Lists of Data

Dynamically Populating VBA Array Variables To Store Lists of Data

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

Prevent Microsoft Office Add-ins From Disappearing

Prevent Microsoft Office Add-ins From Disappearing

Why Is This Happening? This year (July 2016) Microsoft decided to heighten its security features and block files that are...

VBA Code To Loop Through Only Selected Excel Charts

VBA Code To Loop Through Only Selected Excel Charts

What This VBA Code Does The following VBA macro will show you how to loop through only chart objects that...

VBA Code To Find And Replace Words Within Specific File Names In A Folder

VBA Code To Find And Replace Words Within Specific File Names In A Folder

What This VBA Code Does I often have a routine of copying files from one month to another. The only...

Microsoft Word VBA To Save Document As A PDF In Same Folder

Microsoft Word VBA To Save Document As A PDF In Same Folder

What This VBA Macro Code Does The business world has increasingly become more reliant on mobile computing with devices such as...

PowerPoint VBA To Save Presentation As A PDF In Same Folder

PowerPoint VBA To Save Presentation As A PDF In Same Folder

What This VBA Code Does The business world has increasingly become more reliant on mobile computing with devices such as...

VBA Function To Determine What Is Currently Selected On Spreadsheet

VBA Function To Determine What Is Currently Selected On Spreadsheet

What This VBA Macro Does This VBA function is a handy piece of code that categorizes what is currently selected...

VBA Macro Code To Create Monthly Folders Inside A Parent Folder

VBA Macro Code To Create Monthly Folders Inside A Parent Folder

What This VBA Code Does I often find myself needing to set up monthly folders for routine reports. Instead of...

VBA Code To Remove Line Series Markers From All Charts On Excel Spreadsheet

VBA Code To Remove Line Series Markers From All Charts On Excel Spreadsheet

What This VBA Code Does It happened again today...I received 10 Excel line charts that needed to be "properly" formatted...

How To Ensure Your Microsoft Office VBA Add-in File Is Installed & Loaded

How To Ensure Your Microsoft Office VBA Add-in File Is Installed & Loaded

What This VBA Code Does There may be times when you want to incorporate code from your add-ins into other...

VBA Code To Remove Cell Fill Colors

VBA Code To Remove Cell Fill Colors

What This VBA Code Does Here is a simple VBA macro that will remove any fill colors from your selected...

Limit Value Of Userform Textbox To Positive Whole Numbers With VBA

Limit Value Of Userform Textbox To Positive Whole Numbers With VBA

What This VBA Code Does I just got done updating a VBA userform requiring a textbox that would only accept...

VBA Function To Determine If An Excel File Name Is Valid

VBA Function To Determine If An Excel File Name Is Valid

What This VBA Macro Code Does I've written a few macros over the past few days that have required the...

VBA Code To Alphabetize Cell Text While Excluding Certain Short Words

VBA Code To Alphabetize Cell Text While Excluding Certain Short Words

The following VBA code was inspired by a YouTube video I came across where Excel MVP Oz Du Soleil and...

VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

What This VBA Macro Code Does When you are trying to understand an unfamiliar workbook or Excel model, it can...

VBA Code To Change All Shape & Chart Placement Properties

VBA Code To Change All Shape & Chart Placement Properties

What This VBA Macro Does I deal with shapes and charts on a daily basis and one of my (many)...

VBA Code To Measure Selected Cell Range Height & Width In Pixels

VBA Code To Measure Selected Cell Range Height & Width In Pixels

What This VBA Macro Code Does Below is a simple VBA macro I used to measure a group of cells...

VBA To Check If Selected Cells Are Empty

VBA To Check If Selected Cells Are Empty

What This VBA Code Does Back in my early days of teaching myself how to write VBA, I found myself...

VBA To Quickly Save As PDF Document From Selected Excel Worksheets

VBA To Quickly Save As PDF Document From Selected Excel Worksheets

What This VBA Macro Code Does The business world has increasingly become more reliant on mobile computing with devices such as...

Preventing Users From Printing Your Excel Workbook Tabs With VBA

Preventing Users From Printing Your Excel Workbook Tabs With VBA

Sometimes when you have models that are dealing with sensitive information, you want to take extra steps to prevent that...

How To Create Your Own User-Defined Functions With VBA

How To Create Your Own User-Defined Functions With VBA

Hey everyone! Chris here and I want to introduce you to author/blogger Allen Wyatt. Allen has been running a weekly...

Correcting Shape Assigned Macro Links After Copying Worksheet VBA

Correcting Shape Assigned Macro Links After Copying Worksheet VBA

Transferring VBA Through Worksheet Objects The easiest way to copy over VBA code while copying your worksheets into a new...

Find And Replace All With VBA In PowerPoint

Find And Replace All With VBA In PowerPoint

What This VBA Code Does This post is a follow-up article to Find And Replace With Excel VBA. The following...

VBA Code To Activate A Specific Worksheet When An Excel Workbook Opens

VBA Code To Activate A Specific Worksheet When An Excel Workbook Opens

What This VBA Code Does This macro code will ensure a specific worksheet tab is viewed every time the Excel...

Insert & Delete Table Rows With Worksheet Protection

Insert & Delete Table Rows With Worksheet Protection

What This VBA Code Does When you check the "Insert Rows" option in the Protect Sheets dialog box, it only...

Best Way To Copy & Paste Special Values Only With VBA

Best Way To Copy & Paste Special Values Only With VBA

What This VBA Macro Code Does The following two examples of VBA code show you how you can automate copy...

Remove Unnecessary Sheet References From Excel Formulas With VBA Macro

Remove Unnecessary Sheet References From Excel Formulas With VBA Macro

What This VBA Code Does Have you ever seen a formula in Sheet1 where it is written with references to...

Get Scrollbar To Appear When Launching A VBA Userform

Get Scrollbar To Appear When Launching A VBA Userform

What This VBA Code Does For some reason when you have a scrollable textbox, the scrollbar does not initially appear...

VBA Code to Lighten or Darken Fill Colors in Excel

VBA Code to Lighten or Darken Fill Colors in Excel

I've been on a mission the past two weeks to craft a pair of macros to lighten and dark a...

The VBA Guide To Named Ranges

The VBA Guide To Named Ranges

What Is A Named Range? Creating a named range allows you to refer to a cell or group of cells...

Shortcut To Switch Back And Forth Between Two Excel Worksheet Tabs

Shortcut To Switch Back And Forth Between Two Excel Worksheet Tabs

Is There An ALT-TAB Excel Equivalent? One of my all-time favorite keyboard shortcuts is ALT + TAB. This simple keyboard...

Delete Hidden Tabs or Sheets From Your Spreadsheet

Delete Hidden Tabs or Sheets From Your Spreadsheet

What This VBA Code Does This VBA code will run through all the tabs in your workbook and remove any...

Launch VBA Userforms In Correct Window With Dual Monitors

Launch VBA Userforms In Correct Window With Dual Monitors

What This VBA Code Does Having dual monitors is one of the best ways to increase efficiency as a data...

Loop Through All Chart Sheets In An Excel Workbook

Loop Through All Chart Sheets In An Excel Workbook

What This VBA Code Does There are two types of Sheets within an Excel Workbook. Worksheets Chart Sheets The below...

How To Trigger Your VBA Macros To Run Based On A Specific Cell Value Change

How To Trigger Your VBA Macros To Run Based On A Specific Cell Value Change

Today we are going to discuss how you can automatically make your VBA code execute based on a specific cell...

Remove A Specific Fill Color From Your Spreadsheet

Remove A Specific Fill Color From Your Spreadsheet

What This VBA Code Does This VBA macro code will allow you to remove a specific fill color from your...

Delete All Blank Worksheets In Your Excel Workbook With VBA

Delete All Blank Worksheets In Your Excel Workbook With VBA

What This VBA Code Does This is a great little snippet of code I often use whenever I am cleaning up...

Remove Duplicate Paragraphs From The Entire Word Document

Remove Duplicate Paragraphs From The Entire Word Document

What This VBA Code Does This VBA macro code will go through your Active Word document and remove any duplicate...

Remove Consecutive Carriage Returns Throughout Entire Word Document

Remove Consecutive Carriage Returns Throughout Entire Word Document

What This VBA Code Does This VBA macro code with go through the Active Word Document and remove any instances...

Loop Through A Specific Control Type Within A VBA UserForm

Loop Through A Specific Control Type Within A VBA UserForm

What This VBA Code Does These VBA macro snippets will show you how to target and loop through specific controls...

VBA Code To Add An In-Spreadsheet Hyperlink To A Picture Object

VBA Code To Add An In-Spreadsheet Hyperlink To A Picture Object

What This VBA Code Does This VBA code looks for any shape within the ActiveWorkbook with a specific name and...

Format VBA Code Inside A Microsoft Word Document

Format VBA Code Inside A Microsoft Word Document

What This VBA Code Does I have found over the years that organizing your past VBA code snippets can really...

The VBA Guide To Interacting With Text (.Txt) Files

The VBA Guide To Interacting With Text (.Txt) Files

Automating Text Files With VBA Useful? Text files can be a very fast and simple way to read and store...

Apply Math to all Numerical Values Embedded in Text With VBA & Regular Expressions

Apply Math to all Numerical Values Embedded in Text With VBA & Regular Expressions

What This VBA Code Does This VBA code will use the power of Regular Expressions to parse through text and...

Prevent Userform Textbox From Accepting Non-Numerical Values

Prevent Userform Textbox From Accepting Non-Numerical Values

What This VBA Code Does You never know what your users are going to type and that's why it is...

Step-By-Step Create Your First Excel Ribbon Add-in (Easily!)

Step-By-Step Create Your First Excel Ribbon Add-in (Easily!)

One of the most prosperous skills I have picked up over the years as a financial analyst has been the...

The VBA Guide To Sending Excel Attachments Through Outlook

The VBA Guide To Sending Excel Attachments Through Outlook

Quickly Emailing Your Spreadsheets I absolutely love using the Email As Attachment functionality provided by Excel. It's great for quickly...

5 Ways to Create A Dynamic Auto-Adjusting VBA Range

5 Ways to Create A Dynamic Auto-Adjusting VBA Range

Dynamic Code Is Vital! A huge turning point for me when I was teaching myself how to write VBA was...

Add New Worksheet Tabs With A Range Of Sheet Names

Add New Worksheet Tabs With A Range Of Sheet Names

What This VBA Code Does This VBA macro will take a list of sheet names within an Excel table and...

A Fast Way To Clean & Trim Cell Values With VBA Code

A Fast Way To Clean & Trim Cell Values With VBA Code

What This VBA Macro Code Does I found this code snippet on an Ozgrid forum post written by a fellow...

How to Easily Install/Uninstall Excel VBA Add-in Files

How to Easily Install/Uninstall Excel VBA Add-in Files

Installing Your Excel Add-in1. Ensure Your Excel Add-in File Is Unblocked2. Save Your Excel Add-in File To Your Computer3. Enable...

Best Way To Paste Special Excel Objects As PowerPoint Images

Best Way To Paste Special Excel Objects As PowerPoint Images

Quality Matters I've written many times in the past on how the quality and formatting of your work can separate...

Ask If User Wants To Save File Before Executing VBA Macro

Ask If User Wants To Save File Before Executing VBA Macro

What This VBA Code Does In Excel and Microsoft Word you cannot undo a macro once it has run. Sometimes...

Remove Pesky Double Spaces Between Sentences In Microsoft Word

Remove Pesky Double Spaces Between Sentences In Microsoft Word

**Hey, it's Chris here! The following is a guest post by a fellow VBA blogger named Ryan Wells who has...

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...

Automate Building A Table Of Contents For Your Spreadsheet With VBA

Automate Building A Table Of Contents For Your Spreadsheet With VBA

Managing Large Workbooks I've been working with a bunch of rather large Excel workbooks lately and it has come to...

Loop An Input Box Until It Receives Correct or Valid Entry

Loop An Input Box Until It Receives Correct or Valid Entry

What This VBA Code Does This VBA code will show how to keep cycling through an input box prompt until...

Count The Number of Character or Phrase Occurences Within A String With VBA

Count The Number of Character or Phrase Occurences Within A String With VBA

What This VBA Code Does Whether you are wanting to know how many times a double 'S' appears in the...

Applying An Alphabetical Sort To Your VBA Array List

Applying An Alphabetical Sort To Your VBA Array List

What This VBA Code Does Sometimes it is vital to get your lists in order. Below are a couple of...

Remove Blank Rows & Columns With This VBA Macro

Remove Blank Rows & Columns With This VBA Macro

Removing Blanks From Your Data A question I see asked a great deal on Excel forums is how to delete...

The VBA Coding Guide For Excel Charts & Graphs

The VBA Coding Guide For Excel Charts & Graphs

Charts, Charts, & More Charts! Graphical visualizations are arguably the pinnacle of how an analyst shares his/her results and possessing...

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 Remove Duplicate Cell Values Or Entire Rows

VBA Code To Remove Duplicate Cell Values Or Entire Rows

What This VBA Code Does Sometimes when you are cleaning up all the cobwebs of your data, you discover your...

How To Determine Shadow Settings of A Shape With VBA

How To Determine Shadow Settings of A Shape With VBA

What This VBA Code Does Shadows have 5 characteristics that do not easily translate from the slide view into VBA...

Determine The Current ActiveShape In PowerPoint With VBA

Determine The Current ActiveShape In PowerPoint With VBA

What This VBA Code Does This code will set a variable named ActiveShape to equal the shape that is currently...

VBA Advanced Filters: Automate Filtering Specific Values

VBA Advanced Filters: Automate Filtering Specific Values

It's pretty straight forward to filter down on specific values in your data with VBA code.  You just list out...

Aligning Shape Objects With VBA Code

Aligning Shape Objects With VBA Code

What This VBA Does I could not find any way to call the Excel-based alignment actions with VBA, so I...

Merge All Paragraph Breaks In Microsoft Word After Copying Text From PDFs

Merge All Paragraph Breaks In Microsoft Word After Copying Text From PDFs

What This VBA Code Does This past weekend I was tasked with recreating a PDF document in Microsoft Word. Unfortunately,...

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...

VBA Code To Clear Cells Not Containing A Specific Word Or Phrase

VBA Code To Clear Cells Not Containing A Specific Word Or Phrase

What This VBA Code Does This brief macro code with go through each cell in a designated range and determines...

How To Use VBA Code To Copy Text To The Clipboard

How To Use VBA Code To Copy Text To The Clipboard

Update! Better Solution from ExcelHero Excel MVP Daniel Ferry from ExcelHero graciously provided a much more eloquent solution than my...

How To Determine If A Workbook or Worksheet Is Password Protected With Excel VBA

How To Determine If A Workbook or Worksheet Is Password Protected With Excel VBA

What This Does If you want to prevent errors from occurring when you macro code is running, it may be...

Loop Through All Tables In Your Excel Workbook or Worksheet

Loop Through All Tables In Your Excel Workbook or Worksheet

What This Does If you have an Excel workbook or worksheet that houses a large number of tables and you...

Automatically Extending Excel Chart Series’ Ranges For Next Year

Automatically Extending Excel Chart Series’ Ranges For Next Year

It's That Time Of Year Again! For most of us, the months of November and December are spent preparing our...

Make All Charts Plot Non-Visible Cells in Your Excel Workbook

Make All Charts Plot Non-Visible Cells in Your Excel Workbook

What This Does When you create a chart in Microsoft Excel, the chart's default setting is to not graph any...

How To Run Personal VBA Macros in Microsoft PowerPoint

How To Run Personal VBA Macros in Microsoft PowerPoint

PowerPoint Is Not Excel! I have spent probably 90% of my Microsoft Office usage inside Excel.  Because of this, I...

Excel QAT Setups From Some Of The Excel Community’s Finest

Excel QAT Setups From Some Of The Excel Community’s Finest

What's a QAT? QAT is short for Quick Access Toolbar and this bar is typically setup to store frequently used Excel functionalities;...

How To View PowerPoint Add-in VBA Code Inside Visual Basic Editor

How To View PowerPoint Add-in VBA Code Inside Visual Basic Editor

Where Did My Code Go? That was the question I was asking myself when I first began to create PowerPoint...

Retrieve Excel Cell’s Font & Fill RGB Color Code

Retrieve Excel Cell’s Font & Fill RGB Color Code

What This Does Appearance can play a huge factor in the professionalism of your spreadsheet's presentation.  Often there are times...

Highlight All Cells Containing A Specific Value

Highlight All Cells Containing A Specific Value

What This Does: This code will search all of the cells in your worksheet that have data entered into them...

Determining The ActiveShape On Your Spreadsheet With VBA

Determining The ActiveShape On Your Spreadsheet With VBA

What This Does There are times when you would like to know information about the currently selected shape on your...

Prevent Your VBA Code From Running While In Read-Only Mode

Prevent Your VBA Code From Running While In Read-Only Mode

What This Does I had an instance where I needed to prevent users from running a workbook's macros unless the...

Dynamically Change Every Pivot Table Data Source Range Inside A Workbook With This VBA Macro Code

Dynamically Change Every Pivot Table Data Source Range Inside A Workbook With This VBA Macro Code

What This Does This VBA code will allow you to instantly update all your Pivot Tables inside a workbook and...

Break All External Links In Your Excel Workbook

Break All External Links In Your Excel Workbook

What This Does This little macro code will go through all the external links in your workbook and break the...

Adjust Object Positioning Property To All Shapes & Images On Your Excel Worksheet

Adjust Object Positioning Property To All Shapes & Images On Your Excel Worksheet

What This Does Ever have an instance where you have a TON of shapes or images on your spreadsheet and...

Copy & Paste Multiple Excel Tables Into Microsoft Word With VBA

Copy & Paste Multiple Excel Tables Into Microsoft Word With VBA

Moving Excel Tables Into Various Word Pages  This post is an add-on to a previous post I wrote covering how...

How To Remove Only Non-Formula Values From Cells

How To Remove Only Non-Formula Values From Cells

What This VBA Code Does It's that time of year again where I have been tasked to go through and...

The VBA Guide To Excel Pivot Tables [Tons Of Examples]

The VBA Guide To Excel Pivot Tables [Tons Of Examples]

All About The Pivot Tables! Pivot Tables and VBA can be a little tricky initially.  Hopefully this guide will serve...

Setting The Proper Password Protection Using VBA Coding

Setting The Proper Password Protection Using VBA Coding

Prevent Destruction Many times I use worksheet protection to prevent my users from accidentally breaking formulas or disrupting formatting.  With...

Break All External Links In Your PowerPoint Presentation

Break All External Links In Your PowerPoint Presentation

What VBA Code Does This PowerPoint VBA macro code will break any external link from your PowerPoint presentation.  Typically these occur...

Loop Through All Form Control Checkboxes On Excel Spreadsheet

Loop Through All Form Control Checkboxes On Excel Spreadsheet

What This VBA Code Does This code will loop through each of your Form Control checkboxes and let you 'do...

Convert Externally Linked Graphs Into Pictures In Your PowerPoint Presentation

Convert Externally Linked Graphs Into Pictures In Your PowerPoint Presentation

What This VBA Code Does This PowerPoint VBA macro code will cycle through all the externally linked charts in your...

Loop Through Each Slide In Your Active PowerPoint Presentation

Loop Through Each Slide In Your Active PowerPoint Presentation

What This VBA Code Does Often times we want to make changes that affect every slide in the PowerPoint presentation....

How To Remove Excel Tab Colors With VBA Code

How To Remove Excel Tab Colors With VBA Code

Not So Simple When the Macro Recorder Tries to Play Tricks Today I was writing a macro that automatically highlighted...

Classified Data: Find All Numbers And Replace Them With X’s In Text

Classified Data: Find All Numbers And Replace Them With X’s In Text

Recently I found myself in a situation where another company wanted to see the formatting of numerous reports and presentations...

How To Mimic ThisPresentation In VBA For PowerPoint

How To Mimic ThisPresentation In VBA For PowerPoint

What This VBA Code Does It's unfortunate that the Microsoft developer's did not include a ThisPresentation class in PowerPoint's VBA...

The Fastest Way To Convert Numbers Stored As Text To Numbers & Dates

The Fastest Way To Convert Numbers Stored As Text To Numbers & Dates

What This VBA Code Does I have always hated the time it takes to convert text to numbers, especially on...

VBA Code To Save As A New Version If File Already Exists

VBA Code To Save As A New Version If File Already Exists

Version Control Keeping track of different versions of a file has always been a pain for me.  I am grateful...

Loop Through & Make Changes To All Excel Charts In The ActiveWorkbook

Loop Through & Make Changes To All Excel Charts In The ActiveWorkbook

What This VBA Code Does Keeping all your charts perfectly formatted can be extremely tedious work!  It's much easier to...

Remove Plus Signs From The Beginning of Excel Formulas

Remove Plus Signs From The Beginning of Excel Formulas

What This VBA Code Does It's probably just my OCD acting up but I HATE the look of formulas beginning...

How To Filter Excel Data In A PowerPoint Presentation

How To Filter Excel Data In A PowerPoint Presentation

PowerPoint Filtering This was a great idea that came from a reader named Chris Morgan. He wanted to know if...

Selecting Non-Blank Cells In An Excel Column

Selecting Non-Blank Cells In An Excel Column

What This VBA Code Does The below VBA macro code will allow you to select only the cells in a...

Dynamically Change A Pivot Table’s Data Source Range With This VBA Macro Code

Dynamically Change A Pivot Table’s Data Source Range With This VBA Macro Code

What This VBA Code Does Stop creating the same Pivot Table every month for your monthly data extracts! Create a...

VBA Copy/Paste Multiple Excel Ranges To PowerPoint Slides

VBA Copy/Paste Multiple Excel Ranges To PowerPoint Slides

Stop Manually Copying and Pasting! This post is a continuation of the current most popular blog post on The Spreadsheet Guru...

Loop Through All Currently Open Workbooks And Modify Them

Loop Through All Currently Open Workbooks And Modify Them

What This VBA Code Does This bit of VBA code shows you how to loop through all currently open Excel...

The VBA Guide To ListObject Excel Tables

The VBA Guide To ListObject Excel Tables

All About The Tables For a data analyst, Excel Tables are a necessity!  They are the most efficient way to...

Filter Data With An Excel Table Read Into A VBA Array

Filter Data With An Excel Table Read Into A VBA Array

What This VBA Code Does Many times it is much easier to tweak VBA code through a spreadsheet versus changing the...

VBA Code To Add Text To MS Word Header & Bold First Line Of Text

VBA Code To Add Text To MS Word Header & Bold First Line Of Text

What This VBA Code Does  This VBA code allows you to automate adding specific text (single or multiple lines) to...

Loop Through All Worksheets In All Currently Open Workbooks

Loop Through All Worksheets In All Currently Open Workbooks

What This VBA Code Does This VBA macro code will cycle through each worksheet in every currently open Excel workbook...

Automatically Apply Spell Checker’s Suggestion

Automatically Apply Spell Checker’s Suggestion

What This VBA Code Does This is a nifty macro.  It will go through your Microsoft Word document and automatically...

Delete Blank Cells Or Entire Blank Rows Within A Range

Delete Blank Cells Or Entire Blank Rows Within A Range

What This VBA Code Does Many times we as data analyzers receive data that is not so pretty (aka unorganized)....

VBA Copy/Paste An Image, Text, & Table (Excel to Word)

VBA Copy/Paste An Image, Text, & Table (Excel to Word)

Taking A Previous Post One Step Further This will build from a post I previously wrote entitled Copy & Paste An...

Insert Picture Into Word Header With VBA

Insert Picture Into Word Header With VBA

What This VBA Code Does The VBA code below shows how you can automate inserting and image (ie company logo)...

Insert Single Or Multiple Excel Rows With VBA

Insert Single Or Multiple Excel Rows With VBA

What This VBA Code Does  Learn how to insert single or multiple rows with VBA macro code in your Excel...

VBA To Copy/Paste Excel Table Into Microsoft Word

VBA To Copy/Paste Excel Table Into Microsoft Word

Moving An Excel Table Into A New Word Document In this post you will learn how to write VBA code...

Function To Determine If Column Heading Exists Inside Excel Table

Function To Determine If Column Heading Exists Inside Excel Table

What This VBA Code Does This VBA function tests to see if a specific column heading name already exists inside...

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...

VBA For Excel’s Form Control Combo Boxes

VBA For Excel’s Form Control Combo Boxes

You're VBA Combo Box Cheat Sheet In this post I am going to share everything I know about using VBA...

Insert Single or Multiple Excel Columns With VBA

Insert Single or Multiple Excel Columns With VBA

What This VBA Code Does This VBA macro shows you how to insert a single column or multiple columns into...

Create A Multi-Line Text String

Create A Multi-Line Text String

What This VBA Code Does If you want to create multiple lines of text you can either use vbNewLine or...

VBA To Add A Confidentiality Footer Statement In Excel, Word, or PowerPoint

VBA To Add A Confidentiality Footer Statement In Excel, Word, or PowerPoint

What This VBA Code Does When handling sensitive data it is vital to display some sort of statement to let...

Loop Through All Excel Files In A Given Folder

Loop Through All Excel Files In A Given Folder

What This VBA Code Does This VBA macro will let you select a folder path and loop through each of...

Find All Instances With VBA

Find All Instances With VBA

What This VBA Code Does This VBA macro with let you specify a value and create an Excel range selection...

Find and Replace All With Excel VBA

Find and Replace All With Excel VBA

What This VBA Code Does These VBA macros will show you various ways to find and replace all for any...

Unhide All Worksheet Tabs In A Workbook At Once

Unhide All Worksheet Tabs In A Workbook At Once

What This VBA Code Does Don't waste your time manually unhiding tabs one by one.  Use this VBA macro to...

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....

Custom Order Of Worksheet Positions

Custom Order Of Worksheet Positions

What This VBA Code Does This macro will allow you to customize a specific order that you want your worksheets...

VBA Pattern Validation (Characters And Numbers)

VBA Pattern Validation (Characters And Numbers)

Today we are going to discuss how you can use VBA to ensure that cell values match a specific pattern. ...

Copy Selected Slides Into New PowerPoint Presentation

Copy Selected Slides Into New PowerPoint Presentation

What This VBA Code Does Sometimes I have a huge PowerPoint deck filled with data slides from all sorts of...

Run VBA Macros When A Spreadsheet Opens or Closes

Run VBA Macros When A Spreadsheet Opens or Closes

Triggering A Macro Via An Event There are many events that Excel keeps track of while you carry out tasks...

VBA Code To AutoFit Columns

VBA Code To AutoFit Columns

What This VBA Code Does In this macro code I list out four different scenarios in which you can use...

Reference A Worksheet Textbox

Reference A Worksheet Textbox

What This VBA Code Does This will reference a specific textbox on a worksheet and add multiple lines of text to...

Copy & Paste An Excel Range Into PowerPoint With VBA

Copy & Paste An Excel Range Into PowerPoint With VBA

Why Do This? I've received a large number of questions on how to command other programs with VBA through Excel....

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...

Bold The Last Word Of Text In A Cell

Bold The Last Word Of Text In A Cell

What This VBA Code Does This bit of VBA code looks at a text string within a specified cell and...

Wrapping an IFERROR Function Around Your Formulas

Wrapping an IFERROR Function Around Your Formulas

What This VBA Code Does This VBA macro will add an IFERROR function around any cell formula in a given...

Resize An Oversized Pasted PowerPoint Image

Resize An Oversized Pasted PowerPoint Image

What This VBA Code Does Ever paste in a picture or chart to your PowerPoint presentation and it's huge...like so...

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...

VBA Code To Create, Modify, & Delete Userforms

VBA Code To Create, Modify, & Delete Userforms

What This VBA Code Does  I found this concept in an Excel forum and it was attributed to an Excel...

Retrieving The File Name & Extension From A File Path String

Retrieving The File Name & Extension From A File Path String

What This VBA Code Does This macro will show you how to manipulate a file path in order to extract...

Remove Last Character From String

Remove Last Character From String

What This VBA Code Does I typically use this kind of functionality if I am trying to compile a list...

Cell Fills (Color, Patterns, & Gradients)

Cell Fills (Color, Patterns, & Gradients)

What This VBA Code Does This will give you a sample of the different types of cell fills you can...

Lock An Image’s Aspect Ratio

Lock An Image’s Aspect Ratio

What This VBA Code Does This code allows you to lock and unlock the Aspect Ratio of a shape or...

Caution Writing PasteSpecial Macros

Caution Writing PasteSpecial Macros

What's The Story? One day I was teaching a co-worker how to create simple macros to use across any of...

Remove Spell Check Indicators (Squiggles)

Remove Spell Check Indicators (Squiggles)

What This VBA Code Does: This code shows a few different ways you can remove those visually irritating little squiggles...

Standard Input Dialog Box

Standard Input Dialog Box

What This VBA Code Does Want to get an input from your user?  Call an Input Dialog Box to get...

Make Your VBA Userform Float On Screen

Make Your VBA Userform Float On Screen

What This VBA Code Does Have you ever wanted to have the ability to click off of a displayed userform...

Create A Shape or Text Box and Format It

Create A Shape or Text Box and Format It

What This VBA Code Does This VBA macro has a ton of great stuff!  First it creates a shape and...

Protect Worksheet But Allow Formatting & Hiding Of Rows Or Columns

Protect Worksheet But Allow Formatting & Hiding Of Rows Or Columns

What This VBA Code Does This snippet of code will give you a couple of scenarios where you can protect...

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...

Loop Through Spreadsheet Option Buttons

Loop Through Spreadsheet Option Buttons

What This VBA Code Does Use can use this loop to figure out which one of your Option Buttons is...

Retrieve The Dimensions Of A Shape In PowerPoint

Retrieve The Dimensions Of A Shape In PowerPoint

What This VBA Code Does: The VBA code below displays a message box with a selected PowerPoint item's Left, Top,...

Paste Special As An Enhanced Metafile

Paste Special As An Enhanced Metafile

What This VBA Code Does Get a great looking image of an Excel Chart or Table by pasting your copied...

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...

Loop Through All Sheets and Worksheets in Excel File With VBA

Loop Through All Sheets and Worksheets in Excel File With VBA

What This VBA Code Does Need to do a task on every sheet or worksheet in your workbook?  Use one...

Delete Only Grouped Columns or Rows

Delete Only Grouped Columns or Rows

What This VBA Code Does This VBA code will loop through the columns/rows on your active worksheet and delete the...

Center An Object (Textbox, Shape, etc…) On Your Slide

Center An Object (Textbox, Shape, etc…) On Your Slide

What This VBA Code Does Basically, anything you can select on your PowerPoint slide is considered an object. What this...

Add Custom Border To All Pictures

Add Custom Border To All Pictures

What This VBA Code Does This VBA code will apply a custom border to all the pictures in your Word...

Clear Non-Formula Cells

Clear Non-Formula Cells

What This VBA Code Does Ever need to just delete content in your spreadsheet but you wanted to keep all...

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)...

PowerPoint “Set” Statements

PowerPoint “Set” Statements

What This VBA Code Does When first learning how to code VBA for PowerPoint, it was a real struggle for...

Modify Font Format (Color, Bold, Underline, Italicize, Size, & Font Type)

Modify Font Format (Color, Bold, Underline, Italicize, Size, & Font Type)

What This VBA Code Does This will give you an overview of the main ways you can change the font...

[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!

X