Code changing color of text stored in ActiveX Text Box

gnaga

Well-known Member
Joined
Jul 9, 2002
Messages
614
Hi,

I am having an ActiveX Text Box control in my worksheet which is linked to a cell data. I want to change the color of the font of the text box based on certain condition. What is the VBA Code for this task?

I am trying with the following but not working.

ActiveSheet.Shapes.Range(Array("TextBox5")).ForeColor = vbYellow
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,103
Office Version
365
Platform
Windows
How about
Code:
    ActiveSheet.TextBox5.ForeColor = vbYellow
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,103
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,077,619
Messages
5,335,275
Members
399,011
Latest member
rodmicpc

Some videos you may like

This Week's Hot Topics

Top