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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 02:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com