Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

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
0
Murray Brown
Asked:
Murray Brown
  • 4
  • 3
2 Solutions
 
Rory ArchibaldCommented:
Forms or ActiveX?
0
 
Rory ArchibaldCommented:
Assuming ActiveX (since it won't work with Forms), something like:
sheet1.Label1.ForeColor = 255

Open in new window

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
Rory ArchibaldCommented:
Yes. (except for Mac versions) :)
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks very much
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now