![]() |
ShowModal = False but Textbox does not show on userform
I have a userform which is shown while a macro is running (Almost like a
status bar). I have set ShowModal property = False to do so. When I pull up the form I do so with: SummaryForm.Show When I do so the textbox in the form does not show. Why is this? When ShowModal = True it pulls the form up and shows the textbox, however it halts my code which I don't want. Thanks EM |
ShowModal = False but Textbox does not show on userform
right after the code that shows the form, add this :
DoEvents see if that helps. -- Gary "ExcelMonkey" wrote in message ... I have a userform which is shown while a macro is running (Almost like a status bar). I have set ShowModal property = False to do so. When I pull up the form I do so with: SummaryForm.Show When I do so the textbox in the form does not show. Why is this? When ShowModal = True it pulls the form up and shows the textbox, however it halts my code which I don't want. Thanks EM |
All times are GMT +1. The time now is 01:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com