Screen Flashing

[Guest]

I just wrote a pretty cool macro (VBA project) but there is some screen
flashing going on and I want to just have the user see a message "Working "
and the mouse to be an hour glass during the process, which takes a few
seconds. How do I do this?

 

[Guest]

Application.ScreenUpdating = False
your stuff
Application.ScreenUpdating = True


you will be surprised how fast your stuff will now run.

 

[Gary Keramidas]

i use something like this. i create a form with a label on it.

then in the code:

application.screenupdating = false

With UserForm1
.Show vbModeless
.Caption = "Fresh Production Data Report"
.Label1 = "Creating Report .........Please Wait"
.BackColor = &H800000
.Label1.ForeColor = &HFFCC99
End With
DoEvents

'execute your code

Unload UserForm1
application.screenupdating = true