View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Scott Scott is offline
external usenet poster
 
Posts: 4
Default 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?