Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Or frmReporting.Repaint
-- John johnf202 at hotmail dot com "Kirk" wrote in message ... Try adding the following before you update your textbox: frmReporting.txtStatus.setfocus //Update text box // go back to wherever you were at before. This may help. Kirk -----Original Message----- I have a form with a text box called txtStatus. I use this to inform the user of the progress of the processes I am running. There are about 20 steps that run over 10 minutes. The code I am trying to use is: frmReporting.txtStatus.Text = "My Message" sub_runmyprocedure The problem is that when I run the code the text box is not updated. If I step through the code I can see it update the txtStatus with my message. If a use a msgbox I can see the text box update with my message: frmReporting.txtStatus.Text = "My Message" msgBox "" sub_runmyprocedure I have tried to use these lines to force the code to pause but it still does not work. frmReporting.txtStatus.Text = "My Message" application.wait 100 sub_runmyprocedure Can anyone help me with this? JohnV . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text format - setting text colour with code | Excel Discussion (Misc queries) | |||
Setting values in a cell | Excel Discussion (Misc queries) | |||
Setting Chart X and Y values indirectly | Charts and Charting in Excel | |||
Auto setting the charts y axis values | Charts and Charting in Excel | |||
Setting values in another workbook | Excel Programming |