×

VBA Formatting

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

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

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

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

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

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

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

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

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

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

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

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

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

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