Problem updating a field on a form

[Brian.Crawford]

I have a form that processes data from a sheet on demand by the user clicking a button the form. Before starting the processing I put the word "Working" in the processed record count field and then at the end (30-60+ seconds later) I place the record count in that field. The code is:
Private Sub frmGetActuals_Click()
With frmManageWorkBook
.ActualsRecdNo = "Working"
FmtTrialBalance
.ActualsRecdNo =GetLastRow(Sheets("Actuals").Range("A:A"))
End With
End Sub
Overall the routine works but does not put the word "working" in the ActualsRecdNo on the form when the user clicks the button. But does put the count in at the end of processing.
HOWEVER - If I put in a breakpoint at the beginning and step through this SUB using the debugger (F8), when it executes .ActualsRecdNo = "Working", it does put the word in the field and displays it on the form.
Go Figure
would the state of;
Application.calculation or
Application.screenupdating
impact this form's display (I though only WS/WB) and if so why would the state be changed by the debugger
Any suggestions
Thanks in advance
Brian

 

[ColinKJ]

Hi Brian,

You would need the Application.ScreenUpdating to = True as it will not display any changes until the process is complete.

When you run it in debug mode, because you are taking it step by step, the screen will be updated.

 

[Brian.Crawford]

Thanks, thought maybe that might be the case
Can you tell me the "scope" of Application.Calculation & Application.Screenupdating. If I set them off in a parent SUB will they stay off throught lower level SUB calls until I reset them in the parent again. Or are they like "On error resume next" only having scope withing the SUB/Fucntion it is in?
thanks
Brian

 

[Brian.Crawford]

did a search and found that both "Application.--" are Excel wide (not just WB) and are determined by the first WB opend and stay until changed.
thanks

 

[Norie]

Since it's a userform you could also try Repaint.

 

[Brian.Crawford]

not familar with that but will check it out
thanks

 

[Norie]

Well Application.ScreenUpdating is application wide - you can use Repaint for just the form.

Me.Repaint

 

[Brian.Crawford]

thanks, will do