Excel 2013 - Need VBA code to update Chart Text Box Font Color based on cell entry

[rz9wqm]

Hi There - hoping someone can help. I am a complete VBA novice and need help. I'd like the font color in my linked text box on chart named "GA" to match font color of $H$4 cell content in sheet "Data Input" when it changes (cell font color currrently changes based on conditional formatting). Have been googling forever and not getting anywhere - any and all help will be greatly appreciated!!

[Norie]

What's the logic behind the conditional formatting?

[rz9wqm]

Not sure if this will answer it: On sheet named ("DataInput"), from a drop-down box in cell $H$3 the user will select the word "Green", "Yellow", or "Red". In cell $H$4 below that, user will see either a Green Circle, Yellow Triangle, or Red X (Webdings Font). The text box on chart (on separate sheet named "GA") is linked to the cell $H$4 on "DataInput" sheet. The text box is updating fine but font color is not matching the Webding Font color seen in cell $H$4.

[rz9wqm]

The conditional formatting is to correctly color the font of the Circle, Triangle or X Webding and is applied to cell $H$4 based on the entry in the drop down box in cell $H$3.

[rz9wqm]

Not sure if this will answer it: On sheet named ("DataInput"), from a drop-down box in cell $H$3 the user will select the word "Green", "Yellow", or "Red". In cell $H$4 below that, user will see either a Green Circle, Yellow Triangle, or Red X (Webdings Font). The text box on chart (on separate sheet named "GA") is linked to the cell $H$4 on "DataInput" sheet. The text box is updating fine but font color is not matching the Webding Font color seen in cell $H$4.

The conditional formatting is to correctly color the font of the Circle, Triangle or X Webding and is applied to cell $H$4 based on the entry in the drop down box in cell $H$3.

[Norie]

That's actually what I needed as it tells me that we can use the change event of the sheet the chart is on to trigger the code to change the font colour on the textbox on the chart.

Can you upload an example workbook with an example chart?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

In the meantime here's some sample code.

Please Login or Register  to view this content.

[rz9wqm]

Here ya go ... thanks for the assist !!

[Norie]

Try this, it goes in the Data Input sheet module which can be accessed by right clicking the sheet tab and selecting View Code.

Please Login or Register  to view this content.

[rz9wqm]

Perfect - you have no idea how much you've helped !!! Thank you !! Have a wonderful day !!