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

"DG" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

Good Idea Thanks,



"Robert Flanagan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> "DG" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>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
>>
>
>

use non modal

myuserform.show vbmodeless

eg

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


"DG" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>