| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| textbox show correct time in userform | Excel Programming | |||
| How to change the return of a textbox from TRUE/FALSE to YES/NO? | Excel Discussion (Misc queries) | |||
| UserForm - ShowModal Error | Excel Programming | |||
| SetFocus to first textbox on userform upon Userform1.Show | Excel Programming | |||
| UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Linear Mode
