Text Box displayed value does not match real value

**khott13** · 10-28-2009, 03:35 PM

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.

**royUK** · 10-28-2009, 03:37 PM

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

**Leith Ross** · 10-28-2009, 03:38 PM

Hello khott13,

Welcome to the Forum!

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

**khott13** · 10-28-2009, 03:48 PM

Sorry about that, I'll be sure to mark my code in the future.

We have noticed that this occurs for both Form and ActiveX control text boxes. It also only occurs to text boxes which have been read using VBA.

Unforunately I can't send a version of the workbook for privacy concerns.

-Kyle