Excel 2003 change color of a label control

Hi

I am using Excel 2010 but have saved my spreadsheet as 1997 to 2003.
I changed to developer mode and then added a label.
How do I change the font color of the label?
Similarily how would I change the background color of a text box
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
Yes. (except for Mac versions) :)
0
 
Rory ArchibaldCommented:
Forms or ActiveX?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Rory ArchibaldConnect With a Mentor Commented:
Assuming ActiveX (since it won't work with Forms), something like:
sheet1.Label1.ForeColor = 255

Open in new window

0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi Rory. Its not an ActiveX control. Just a regular label on a spreadsheet noy a form. Is there a manual way to set this
0
 
Rory ArchibaldCommented:
No, if it's not ActiveX. You can't alter the Forms one.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Will an ActiveX control work with Excel 2003 and maybe previous versions?
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.