#Change subtitle color online code

It is so easy to change the font color and interior color using RGB with the help of code shown in the above examples.We will notice that interior color selected cells A1 to A10 remains unchanged like previous, which is because RGB value resets to 255 if we use value more than 255. Step 6: LetвЂ™s try to change and put the value of Green color more than 255 and see what color we get.

we will see the interior color of the selected cells is now changed to a major Green color. Step 5: Now compile the code by pressing function key F8 and to run the code, click on the Play button located below the menu bar. We will be now giving more weightage to Green color and lesser to Red and Blue colors respectively. Step 4: Now we will be using RGB to fill the new color to the selected cell. Step 3: To change the interior color, we will be using the INTERIOR function along with COLOR in the same format which we saw in Example-1. Step 2: Now select the same sets of cell range from A1 to A10.

Step 1: Open a new module and write the subprocedure for VBA RGB. For this, again we can use the same line of code and do some editing or we can use a new module.

#Change subtitle color online how to

Earlier we have seen the code to change the font colors but here we will be seeing how to change the color of a cell or background color or interior color. In this example, we will be using the same data set which we saw in example-1 which is located in cell A1 to A10. We would see the color fonts of selected range cells nearer to Brown color. Step 6: Now compile the code by pressing function key F8 and to run the code, click on the Play button located below the menu bar. We are giving more weightage to Red color and lesser to Green and Blue respectively as shown below. Step 5: Now we will be using RGB with some random values to change the color Fonts from cell A1 to A10. Step 4: Now to change the color fonts of the selected cells, we will use the FONT function followed by COLOR. Here our range of cell will be from A1 to A10. Step 3: First we will select the cells, whose color we want to change. Step 2: Now in the newly opened Module write the subprocedure of VBA RGB.