Category Archives: VBA

How to set Microsoft Excel cell background color in VBA

Recently I have been working on a VBA project, so I will post some skills or tips I learned and used on Excel VBA program. Today I will share how to change the cell background color in the VBA module.

The property of background color is , and the color is used as Index format. So to setup a cell (row ID: 1, column ID: 12) in Red background color is the below:

Worksheets(1).Cells(1,12).Interior.ColorIndex = 3 ‘change the background color to RED

And you can find more color index in the rest of my post. Continue reading