WallStreetMojo

WallStreetMojo

Home » Learn VBA » VBA Tips » VBA RGB

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 coding of each and every piece, for an example, if you want to reference some portion of the worksheet then we can use RANGE object, if you want to change the font color then we can make use of NAME property of the range then write 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.

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 “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 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 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 background color choose “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 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 “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.

Recommended Articles

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 downloadable excel template. Below are some useful excel articles related to VBA-

0 Shares
Share
Tweet
Share