how to chang cell color to text in excel worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greatatulpanday@gmail.com - 17 Dec 2007 13:22 GMT

Hi
I am very new comer in excel VBA programming please send me the
VBA code how to change the cell color to text value.

Atul

Reply to this Message

Mika Oukka - 17 Dec 2007 14:56 GMT

Record a macro and do your changes to the selected cell/range and in the
code you will generate something like this
Selection.Font.ColorIndex = 3
where the 3 represents the colorindex for red colour which I chose during
recording.

Hope This Helps

Regards,
Mika Oukka

> Hi
> I am very new comer in excel VBA programming please send me the
> VBA code how to change the cell color to text value.
>
> Atul

Reply to this Message