VBA RGB

Excel VBA RGB Color

RGB can be also termed as red green and blue, this function is used to get the numerical value of the color value, this function has three components as a named range and they are red, blue and green the other colors are considered as the components of these three different colors in VBA.

In VBA, everything boils down to the coding of each and every piece. For example, if you want to reference some portion of the worksheet, then we can use the RANGE object. If you want to change the font color, then we can make use of the NAME property of the range then write the font name that we needed but imagine a situation of changing the color of the font or background color of the cell for this, we can make use of built-in VB colors like, vbGreen, vbBlue, vbRed, etc.…But we have dedicated function to play around with different colors, i.e., RGB function.

VBA-RGB

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: VBA RGB (wallstreetmojo.com)

Below is the syntax of the RGB color function.

VBA RGB Syntax

As you can see above, we can supply three arguments, i.e., Red, Green, and Blue. All these three parameters can accept integer numbers ranging from 0 to 255 only, and the result of this function will be the  “Long” data type.

Change Color of Cells using VBA RGB Function

You can download this VBA RGB Excel Template here – VBA RGB Excel Template

Example #1

For example, we have numbers from cell A1 to A8, as shown in the below image.

VBA RGB Example 1

For this range of cells, we will try to change the font color to some random color by using the RGB function.

Start the macro procedure first.

Code:

Sub RGB_Example1()

End Sub
VBA RGB Example 1.0

First, we need to reference the range of cells of fonts we want to change the color of. In this case, our range of cells is A1 to A8, so supply the same by using the RANGE object.

Code:

Sub RGB_Example1()

  Range ("A1:A8")

End Sub
Example 1.2

Put dot to see the IntelliSense list of RANGE object. From the IntelliSense list, we are trying to changing the color of the font, and so choose the FONT property from the list.

Code:

Sub RGB_Example1()

  Range("A1:A8").Font

End Sub
VBA RGB Example 1.3

Once the FONT property was chosen in this property, we are trying to change the color, so choose the color property of the FONT.

Code:

Sub RGB_Example1()

  Range("A1:A8").Font.Color

End Sub
Example 1.4

Put equal sign and open RGB function.

Code:

Sub RGB_Example1()

  Range("A1:A8").Font.Color = RGB(

End Sub
VBA RGB Example 1.5

Give random integer numbers ranging from 0 to 255 for all the three arguments of the RGB function.

Code:

Sub RGB_Example1()

  Range("A1:A8").Font.Color = RGB(300, 300, 300)

End Sub
 Example 1.9

Ok, now run the code and see the result of font colors of the cells from A1 to A8.

Output:

VBA RGB Example 1.7.0

So, the colors of the font changed from black to some other. Color depends on the numbers we give to the RGB function.

Below are RGB color codes to get some of the common colors.

Example 1.8

You can just change the integer number combination from 0 to 255 to get the different sorts of colors.

Example #2

For the same range of cells, let’s see how to change the background color of these cells.

First, supply the range of cells by using the RANGE object.

Code:

Sub RGB_Example2()

  Range ("A1:A8").

End Sub
VBA RGB Example 2

This time we are changing the background color of the mentioned cells, so we have nothing to do with FONT property now to change the background color, choose the “Interior” property of the RANGE object.

Code:

Sub RGB_Example2()

  Range("A1:A8").Interior

End Sub
Example 2.1

Once the “Interior” property is selected, a put dot to see the properties and methods of this “Interior” property.

Code:

Sub RGB_Example2()

  Range("A1:A8").Interior.

End Sub
VBA RGB Example 2.2

Since we are changing the interior color of the mentioned cells, choose the “Color” property.

Code:

Sub RGB_Example2()

  Range("A1:A8").Interior.Color

End Sub
Example 2.3

To set the interior color property of the range of cells (A1 to A8) out the equal sign and open RGB function.

Code:

Sub RGB_Example2()

  Range("A1:A8").Interior.Color = RGB(

End Sub
VBA RGB Example 2.4

Enter the random number as you want.

Code:

Sub RGB_Example2()

  Range("A1:A8").Interior.Color = RGB(0, 255, 255)

End Sub
Example 2.6

Run the code and see the background color.

Output:

VBA RGB Example 2.5.0

The background color has been changed.

Things to Remember Here

  • RGB stands for Red, Green, and Blue.
  • A combination of these three colors will give different colors.
  • All these three parameters can accept integer values between 0 to 255 only. Any numbers above this will be reset to 255.

This has been a guide to VBA RGB. Here we discuss how to change the color of the interior cell (background, font) in excel VBA by putting different integer numbers in RGB function with examples and a downloadable excel templateBelow are some useful excel articles related to VBA-

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>