how to chang cell color to text in excel worksheet

  • Thread starter Thread starter Greatatulpanday
  • Start date Start date
G

Greatatulpanday

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
 
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
 
Back
Top