Display a userform and have program continue

  • Thread starter Thread starter DG
  • Start date Start date
D

DG

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
 
DG, I prefer to do statusbar messages that continually change. If you have
loops, that is easy.

application.statusbar ="some text"
applicaton.statusbar = false 'clears the statusbar when done

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Good Idea Thanks,



Robert Flanagan said:
DG, I prefer to do statusbar messages that continually change. If you
have loops, that is easy.

application.statusbar ="some text"
applicaton.statusbar = false 'clears the statusbar when done

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
Click to expand...
 
use non modal

myuserform.show vbmodeless

eg

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