- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hello,
I have met this issue in multiple projects of mine so I think I should better come to ask.
I have a Userform containing user input and start button, once the button clicked I hide this Userform, run the code, and then show the Userform again for another run.
The problem is, the code does not seem to run before the "UserForm.Show" at the end of my code. The changes made by the code only display in the drawing after I close the Userform, or when I click the start button on the Userform to make the code run again. How can I update the drawing before showing the Userform?
- UserForm.Show stands at the end of the button_click sub while it is placed right after ErrorHandler of " On Error GoTo"
- I tried to put a msgbox right before the UserForm.Show, the msgbox displays, while the code still does not run.
Solved! Go to Solution.