Modeless Userform problem
 

Hi

Sub Show()
UserForm1.Show vbModeless
DoEvents
UserForm1.Repaint
DoEvents
'stuff here
End Sub


HTH. Best wishes Harald

"Andy" skrev i melding
...
I am trying to create a pop up that tells the user that the macro is
running.
I want to run this as a modeless userform. When the macro runs, the
userform shows the main title bar as expected but the contents of the
userform is just white. How do I correct this?

Modeless Userform problem
 

Andy,

Note that vbModeless isn't supported by Excel 97. It doesn't even compile.

-Scott

"Harald Staff" wrote in message ...
Hi

Sub Show()
UserForm1.Show vbModeless
DoEvents
UserForm1.Repaint
DoEvents
'stuff here
End Sub


HTH. Best wishes Harald

"Andy" skrev i melding
...
I am trying to create a pop up that tells the user that the macro is
running.
I want to run this as a modeless userform. When the macro runs, the
userform shows the main title bar as expected but the contents of the
userform is just white. How do I correct this?