Simple-Moderate Question: How to keep a Text Box From Updating?

[Bill Bisco]

Hello,

I have a form that will be changed by the user and the information displayed subsequently Must be refreshed to reflect the changes.

1 text box on this form changes when the form is refreshed; however, I do not want the number displayed on this text box to visibly change yet.

I would like the user to click another button, later and when this happens the text box will display its actual Value.

Is there a way to do this in VBA?

Sincerely,
Bill

 

[Bill Bisco]

...bump.

Any ideas or is this impossible?