Hi All,
So i've inserted a textbox onto my worksheet and have it referencing a cell (=A1).
But im using a macro in cell A1 to make the cell flash if another cells value (say B2) is >10. This is working great.
What im wondering is, can you make a text box reference another cell and constantly update to match the formatting of that cell as well as the value? Essentially making the text box flash.
???
So i've inserted a textbox onto my worksheet and have it referencing a cell (=A1).
But im using a macro in cell A1 to make the cell flash if another cells value (say B2) is >10. This is working great.
What im wondering is, can you make a text box reference another cell and constantly update to match the formatting of that cell as well as the value? Essentially making the text box flash.
???