Code changing color of text stored in ActiveX Text Box

[gnaga]

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]

How about

    ActiveSheet.TextBox5.ForeColor = vbYellow

 

[gnaga]

Thanks Fluff...It is working fine..

 

[Fluff]

You're welcome & thanks for the feedback