ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ShowModal = False but Textbox does not show on userform (https://www.excelbanter.com/excel-programming/385725-showmodal-%3D-false-but-textbox-does-not-show-userform.html)

ExcelMonkey

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

Gary Keramidas

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