So I have a few text boxes that I created from Shapes and gave it the text properties that I want.

I have the text box linked to a cell on another sheet, i did this in the formula by doing =Sheet2!A2

The problem is that the text box does not always display the information. Especially if A2 is blank then its saved and closed. When i open it and enter something into A2 the text box on sheet 1 does not display A2 many times until I click the text box over and over... and sometimes when I finally get it to display again it reformats everything to default.

Anyone have an idea?