View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default Display a userform and have program continue

use non modal

myuserform.show vbmodeless

eg

Sub xxx()
UserForm1.Show vbModeless
MsgBox "OK?"
End Sub


"DG" wrote in message
...
I want to have a form popup that says "Please Wait.." while the program
continues to run. I changed the ShowModal to False and the form shows but
the "Please Wait.." text does not. The caption in the title bar does show
however.

Is there a way to make this work or is the a betterway to display a wait
message so the user doesn't start hitting keys etc...

DG