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:

Please Login or Register  to view this content.

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.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Added this time only

Also, please say which type of textboxes you are using, maybe attach an example workbook

Hello khott13,

Welcome to the Forum!

What type of text boxes are they: Forms, Control Toolbox, or something else?

Change the data, just leave the textboxes intact.

beter still why bother with TextBoxes?