Would someone please explain to me the distinction between a "modeless" user form and one that is not "modeless"?
With kind regards
Clint Westwood
Replies (4)
Please login or register to join the discussion.
I assume you mean the difference between modeless and modal? A modeless form is one that is "active" at the same time as other forms within an application, whereas a "modal" form deactivates all other forms until it is closed.
So for example, in Excel, the search window is modeless (you can edit cells or use the menu while the form is open), but the "Format cells" window is modal.
Yes the default is modal.
The ramification of using modeless is that your code will continue to run. So, if you want your code to wait until a response to your userform, you must put "userform.show" at the end of a sub. Any code you want to run thereafter needs to be called from the userform code.