VBA RGB

What is Excel VBA RGB Color?

VBA RGB represents the red, green, and blue color options in VBA Excel. With the help of VBA RGB color, we can change the color of the font or a cell, or both. VBA RGB is the dedicated function to utilize the colors red, green, and blue while coding. All other colors are their components ranging from 0 to 255.

Let us understand this function in VBA with a simple example. Suppose we want to change the font color of a cell using the VBA RGB function. Please follow the below steps. First, write the data in the Excel sheet shown below. Here, we have written the days of the week in black. Next, write the below code in a module in Visual Basic in the Developer tab in excel.  Finally, run the code by clicking the Run option in the VBA ribbon. You can see the font color change to magenta (255,0,255).

Code:

Sub VBA_RGB_Ex()
Range(“A1:A10”).Font.Color = RGB(255, 0, 255)
End Sub

How to Change the Color of Cells Using VBA RGB Function?

Excel VBA – All in One Courses Bundle (35+ Hours of Video Tutorials)

If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Examples

Let us look at some examples where we can use the RGB function to color objects in Excel.

Example #1

Here, we will see the use of the RGB function in coloring the font as well as the cell via VBA code.

• Step 1: We have the following data in an Excel sheet.

• Step 2: Open the VBA module in the Developer Tab under Visual Basic and write the below code:

Code:

Sub VBA_RGB_Ex()
Range(“A1:A5”).Font.Color = RGB(255, 0, 255)
Range(“A1:A5”).Interior.Color = RGB(0, 0, 255)
End Sub

• Explanation:

Range(“A1:A5”).Font.Color = RGB(255, 0, 255)- It will give a magenta color to the font value in the cell range A1-A5.

Range(“A1:A5”).Interior.Color = RGB(0, 0, 255)-It will assign a blue color to the interior of the cells in A1-A5.

• Step 3: Run the code by clicking the Run button within the VBA ribbon or F5. We can see the below result in our worksheet.

Example #2

In this example, we will use the RGB function to create a combination of colors in the Excel cells. Here, we will also see the steps to obtain the value of any color using the VBA code.

• Step 1: Write the below code as below.

This code shows the value of red (VBA.ColorConstants.vbRed) in cell A1.

• Step 2: Here, the font color of the A3 cell value is assigned the red color.

• Step 3: This line assigns the value “RED” to cell A3. Cell A2 is assigned an interior color of red.

• Step 4: We write the rest of the code, assigning different colors to the font, cell, and other values to cells B1:B3, C1:C3, and D1:D3.

The above code is used to assign a combination of font colors, text, and cell colors to the D1-D3 cells.

Code:

Sub Using_RGB_Ex()
Range(“A1”).Value = VBA.ColorConstants.vbRed
Range(“A2”).Interior.Color = vbRed
Range(“A3”).Font.Color = vbRed
Range(“A3”).Value = “RED”

Range(“B1”).Value = VBA.ColorConstants.vbGreen
Range(“B2”).Interior.Color = vbGreen
Range(“B3”).Font.Color = vbGreen
Range(“B3”).Value = “Green”

Range(“C1”).Value = VBA.ColorConstants.vbCyan
Range(“C2”).Interior.Color = vbCyan
Range(“C3”).Font.Color = vbCyan
Range(“C3”).Value = “Cyan”

Range(“D1”).Value = VBA.ColorConstants.vbGreen + vbRed
Range(“D2”).Interior.Color = vbGreen + vbRed
Range(“D3”).Font.Color = vbGreen + vbRed
Range(“D3”).Value = “Yellow”
End Sub

• Step 5: Run the code by clicking the Run button within the VBA ribbon, and you can see the below result in your worksheet.

Important Things to Note

• VBA RGB can assign any color or combination using VBA code using VBA code to obtain different shades of red, green, and blue. For example, cyan color is a mix of red(68), green(247), and blue(255).
• The value of the colors is available between 0 to 255 only. If the value exceeds 255, it will reset it to 255.
• We can also find the value of a color using the VBA code.
• The VBA.ColorConstants is used to assign different colors. It has eight color options.
• The input of the Color property is two types:
  • vbColor
  • RGB colors
• vbColors is the easiest way of setting colors in the VBA. However, the color options are minimal.
• RGB has three primary colors, which are combined to give multiple colors.
• VBA RGB function is beneficial in representing the data, as the process of the color change of fonts or cells can be automated.

Frequently Asked Questions (FAQs)

Download Template

This article must be helpful to understand the VBA RGB, with its formula and examples. You can download the template here to use it instantly.

Recommended Articles

This has been a guide to VBA RGB. Here we learn how to change the color of cells using Excel VBA RGB function, with examples & downloadable excel template. You can learn more from the following articles –

• VBA Color Index
• VBA Input Box
• VBA Find