Forum Discussion
Unexpected VBA Behavior: Userform showModal=False & close other Excel files make userform closed
I found that when setting the UserForm with `showModal=False` and close other excel file (not the one contains macro) will make UserForm disappear, too.... I have a long-running macro that user migh...
You can let Microsoft know about this by selecting File > Feedback > Send a Frown in Excel.
HansVogelaar
I see...
Thanks for the suggestion. I've already sent out the problem.
However, even if I sent out the issue, there is no promise that it will be solved right...?
That's correct - I suspect that Microsoft will say the behavior is to be expected.
HansVogelaar
You really know them well XDDDJust in case that they won't solve it, is there anything I can do to solve this issue?
The only one that I can figured out is to disable the close event until the macro finishes it work....
Do you really need the userform to be modeless? If so, I don't know of a better workaround...