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
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