Text Box displayed value does not match real value

Hello,

I have been noticing some strange behavior with some text boxes which are embedded in a worksheet.

Say for instance I saved/closed the workbook with the value of "6" in the text box. When I re-open the workbook and change the value to something different, say "4", it will still display "6" whenever the text box is inactive.

If you click in the text box and make it active, it will then accurately display the new value of "4". We use VBA to read the value of these text boxes using the following code:

txtValue = Sheets(1).checkbox1.Value

The VBA code retrieves the correct value of "4", but it is very misleading to the user that the displayed value is "6" when the text box is inactive.

Anyone else ever encounter this?

Thanks!
Kyle

PS. It does this in both 2003 & 2007.