ExcelBanter - copy cell font colour to textbox?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - copy cell font colour to textbox? (https://www.excelbanter.com/excel-discussion-misc-queries/218098-copy-cell-font-colour-textbox.html)

sophie

copy cell font colour to textbox?

Please can anybody help!!!!

How do I copy the font colour of a cell to a textbox.
Say, cell "A1" font colour changed to RED, then the textbox that is linked
to that cell changes as well.
--
Sophie

All times are GMT +1. The time now is 07:49 AM.