Label caption runtime changes

[Kaulana]

Want to change a label when command button clicked to say "Processing" while it processes. Caption doesn't change till the processing is over and a message box stops the run. However, the caption does change as soon as the button is pressed when I step through it.

Has to be something simple they never taught me in school. Wait a minute, I didn't go to school for this. Hmm. Kaulana (aka New Daddy Bob)

http://www.bobfarley.com

 

[JustinEzequiel]

try somthing like

[tt]Label1.Caption = "Processing"
Label1.Refresh

' processing code here[/tt]

 

[Kaulana]

Thanks for try, Justin, but Refresh not an available option for labels in VBA. Kaulana (aka New Daddy Bob)

http://www.bobfarley.com

 

[JustinEzequiel]

try

Label1.Caption = "Processing"
Label1.Parent.Repaint
' processing code here

or just

Label1.Caption = "Processing"
Me.Repaint
' processing code here

or if that still does not work try

Label1.Caption = "Processing"
DoEvents
' processing code here