#ADD CELL BACKGROUND COLOR WORD UPDATE#

Using the example above:Ĭolor = red value + green value multiplied by 256 + blue value multiplied by 65.536 (65.536 = 256*256) Interior.Color is equal to 64.100, which is a calculated number based on the RGB values.

So what is this number? If you start your macro recorder and set the background color of a cell you will get something like this: cells’ background color, font type, size, borders etc).Ī cell background color is defined by its Interior.Color property (unfortunately on MSDN I did not find too much information about it).

find a property which is the same for a group of cells and look for that property with your code (e.g.

#ADD CELL BACKGROUND COLOR WORD UPDATE#

apply names and refer to them (though if you forget to name a cell or range you are going to be doomed, also when there is a structure change (new field or ‘no more needed’ field) you still have to update your code.hard code all cells/ranges reference in your code (which might cause severe hair loss when there is a structure change).For example imagine a template with lot of input cells and you implement a ‘Reset’ feature. There are very few other situations I hate more than a colored tab without legend and you need to find out do they have a meaning or just leftovers, but that is an another topic).Ĭolors might have significant job when you are working with VBA. (Side-note: if you are lucky there is also going to be a legend to explain what the colors mean. Colors usually plays important roles in reports, forms, templates etc.

Add cell background color word