Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code stops while Userform Shown
I have some code which shows a userform. While the form is shown I want to
run through a lenthy routine and periodocially update a label with status strings. However, once the userform is shown, the code stops progressing. I can only get the code to progress if I close the form. It almost as if I have set break in the code on the first line after the Userform1.Show statement. Any ideas? Sub DoSomething() Userform1.Show Call DoSomethingElse End Sub Call DoSomethingElse Userform1.Label1 = "Show something" End Sub Thanks EM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code stops while Userform Shown
Duh. Needed to ste ShowModal = False to make modeless.
Thanks EM "ExcelMonkey" wrote: I have some code which shows a userform. While the form is shown I want to run through a lenthy routine and periodocially update a label with status strings. However, once the userform is shown, the code stops progressing. I can only get the code to progress if I close the form. It almost as if I have set break in the code on the first line after the Userform1.Show statement. Any ideas? Sub DoSomething() Userform1.Show Call DoSomethingElse End Sub Call DoSomethingElse Userform1.Label1 = "Show something" End Sub Thanks EM |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code stops while Userform Shown
The way to do that and make your code self-documenting is to use the
built-in VB constant... Userform1.Show vbModeless -- Rick (MVP - Excel) "ExcelMonkey" wrote in message ... Duh. Needed to ste ShowModal = False to make modeless. Thanks EM "ExcelMonkey" wrote: I have some code which shows a userform. While the form is shown I want to run through a lenthy routine and periodocially update a label with status strings. However, once the userform is shown, the code stops progressing. I can only get the code to progress if I close the form. It almost as if I have set break in the code on the first line after the Userform1.Show statement. Any ideas? Sub DoSomething() Userform1.Show Call DoSomethingElse End Sub Call DoSomethingElse Userform1.Label1 = "Show something" End Sub Thanks EM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform moves when hidden and shown again. | Excel Programming | |||
UserForm initialize event run when UserForm is shown | Excel Programming | |||
Using Cells while UserForm shown | Excel Programming | |||
Userform shown in windows other than Excel | Excel Programming | |||
Userform to enter values and shown in same userform in list | Excel Programming |