how to chang cell color to text in excel worksheet

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
 
M

Mika Oukka

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel VBA 1
Excel VBA 0
How to get cell background color 2
VBA insert comment only when cell in a range changes first time 5
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Text Color Functions 1

Top