Join the Newsletter Product Help
Search
×
Excel VBA About Shop

Colors

3 Ways To Alternate Row Colors in Excel [Guide]

3 Ways To Alternate Row Colors in Excel [Guide]

How to Alternate Shading Row Colors (Banded Rows) While Microsoft Excel does not have a dedicated row banding button to...
Microsoft Office 2023 Theme Color Update

Microsoft Office 2023 Theme Color Update

Introducing the New 2023 Microsoft Office Color Theme Over the years, we've seen the Microsoft Office suite undergo a plethora...
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 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 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)...
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 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...
Using Cell Formatting Logic With Excel Formulas

Using Cell Formatting Logic With Excel Formulas

Wishful Thinking?  Have you ever had a time where you wished you could write an IF formula in Excel based on...
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...
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...