Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,562
- Office Version
- 365
- 2016
- Platform
- Windows
I have a section of code that processes a large amount of complex calculations over a large database. It is executed through a button push on a userform.
When the user initiates this process, it is not uncommon for the user to believe that the process has stopped, or a crash has happened.
I would like to use a message userform (a simple userform with a label with the message "Please wait...") to keep the user posted.
It will show prior to the process, and unload following.
This has the appearance, but as long as the helper userform is showing, the process pauses. Only after the helper userform is closed does the process start. Not really what I wanted.
I changed the helper userform's showmodal property to false. The process completes with the helper userform displayed, but it is blank. (Just the window border and a white blank background.
Thoughts?
When the user initiates this process, it is not uncommon for the user to believe that the process has stopped, or a crash has happened.
I would like to use a message userform (a simple userform with a label with the message "Please wait...") to keep the user posted.
It will show prior to the process, and unload following.
Code:
With ws_sched
.AutoFilterMode = False
pleasewait.Show
With .Range("A:W")
.AutoFilter field:=1, Criteria1:=r_type
.Resize(Rows.Count - 1).Offset(1).EntireRow.Delete
End With
Unload pleasewait
.AutoFilterMode = False
End With
This has the appearance, but as long as the helper userform is showing, the process pauses. Only after the helper userform is closed does the process start. Not really what I wanted.
I changed the helper userform's showmodal property to false. The process completes with the helper userform displayed, but it is blank. (Just the window border and a white blank background.
Thoughts?