Updating a Text Box in my Workbook

[Guest]

Excel 2002-2003. I have a workbook on which I have a couple of controls.
One is a button that kicks off VBA code that does some processing on some
other workbooks. Another control is a text box that I want to update with
the status of the VBA process. I change the value of the text box
programmatically, but the display does not update. How may I ensure that the
text box value displays the updates?

 

[Tom Ogilvy]

where are the controls located?

 

[Guest]

Controls are located in a file called "Process Woorkbooks.xls" This file
remains with the focus throughout the process unless a msgbox or inputbox
appears from the code behind the controls.

 

[Tom Ogilvy]

controls can be from the control toolbox toolbar or the forms toolbar

control toolbox toolbar controls can be used on Userforms or Worksheets
forms toolbar controls can be used on Dialogsheets or Worksheets or Charts

if on a userform you can use the repaint method, or you might have
screenupdating turned off

if on a worksheet, perhaps you have screenupdating turned off.