Join the Newsletter Product Help
Search
×
Excel VBA About Shop

VBA

If you’re looking to take your Excel skills to the next level, you’re in the right place. In this category, we dive deep into the world of VBA, Microsoft Excel’s powerful programming language. From automating repetitive tasks to creating custom functions and macros, we’ll explore the ins and outs of VBA to help you become a true Excel ninja. Our tutorials and guides are designed for both beginners and experienced users, providing step-by-step instructions, practical examples, and best practices to help you master VBA and unlock its full potential. Get ready to supercharge your productivity and take your Excel game to new heights with our VBA insights and tips!

VBA Charts

See all the guides »
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...
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...
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 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 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...
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 Coding Basics

See all the guides »
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 [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...
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...

VBA Copy/Paste

See all the guides »
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...
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...
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...
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...
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...
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...

VBA Data Cleanup

See all the guides »
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...
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...
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...
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 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...
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 Developing Add-ins

See all the guides »
Dynamic Array Formula Spill Ranges With Charts

Dynamic Array Formula Spill Ranges With Charts

Linking Dynamic Array Formulas into Chart Series With the introduction of Dynamic Array functions in Excel, your spreadsheets can now...
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...
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...
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...
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...
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 Dialog Boxes

See all the guides »
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...
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...
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...
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...
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...

VBA Event Triggers

See all the guides »
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...
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...
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...
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...
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 Files

See all the guides »
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...
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 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...
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...
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 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...

VBA Filter/Sort

See all the guides »
4 PRO Ways to Create A Filtering Search Box [Excel Download]

4 PRO Ways to Create A Filtering Search Box [Excel Download]

Creating A Search Box In Excel It's unfortunate Excel does not have a form control search box (maybe in the...
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...
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...
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...
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...
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...

VBA Form Controls

See all the guides »
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...
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...
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...

VBA Formatting

See all the guides »
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...
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...
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...
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 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...
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 Formulas

See all the guides »
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...
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...
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 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...
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...
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...

VBA Graphics

See all the guides »
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...
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...
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...
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 Miscellaneous

See all the guides »
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...
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...
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...
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...

VBA Named Ranges

See all the guides »
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...
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...

VBA Pivot Tables

See all the guides »
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...
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...
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...
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...
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 Protection

See all the guides »
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...
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...
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 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...
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...
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...

VBA Spreadsheet Grid

See all the guides »
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...
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...
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....
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?...
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...
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...

VBA Tables

See all the guides »
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...
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...
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...
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...
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...

VBA Text Manipulation

See all the guides »
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?...
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 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 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...
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...
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 User-Defined Functions

See all the guides »
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...
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...
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...
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...
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 Userforms

See all the guides »
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...
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...
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...
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...
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...
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...