| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display a userform and have program continue
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display a userform and have program continue
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" 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display a userform and have program continue
Good Idea Thanks,
"Robert Flanagan" wrote in message ... 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" 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I continue a routine while showing a userform? | Excel Programming | |||
| Display Program Status | Excel Programming | |||
| PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic | Excel Programming | |||
| Display an Image in it's associated program | Excel Programming | |||
| Can I program a userform via spreadsheet? | Excel Programming | |||
Linear Mode
