I have a programme that takes some user input from a User Form and then updates the active document based on the details entered by the user. As the documents are quite large the updates take about 20 seconds to complete.
I would like to display a message to the user saying "Please wait while your updates are applied..." but when I use a MsgBox or a User Form to do this, the programme stops and waits for a response to the MsgBox or to the User Form.
Is there a way to display the MsgBox / User Form and have the programme continue executing behind the scenes and then remove the MsgBox / User Form after all the updates are done?
I have checked the Help file for options and looked for properties that may allow this but so far have drawn a blank.
One option I guess would be to use a User Form to display the "Please wait" message and have all of my main code inside that User Form so that it executes when the form opens but I'm sure there must be a tidier way of doing this.