This is another VBA tips I learned with my Excel VBA project. Just wanted to share here for the future reference. Hope you can find it useful as well. The original post was found on tek-tips.com.
The following procedures demonstrate creating, copying, moving and deleting of files and folders using VBA: Continue reading
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