E
ExcelMonkey
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
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