Forum Discussion

Copper Contributor

Sep 21, 2022

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...

TestCloseOtherExcelFile.xlsm16 KB

Copper Contributor

Sep 21, 2022

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...?

HansVogelaar

MVP

Sep 21, 2022

cindy_lu

That's correct - I suspect that Microsoft will say the behavior is to be expected.

cindy_lu
Copper Contributor
Sep 21, 2022
HansVogelaar

You really know them well XDDD
Just 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....
- HansVogelaar
  MVP
  Sep 21, 2022
  cindy_lu
  
  Do you really need the userform to be modeless? If so, I don't know of a better workaround...
  - cindy_lu
    Copper Contributor
    Sep 21, 2022
    HansVogelaar
    
    I believe that being modeless is a must.
    All my users are heavy excel users. It is nearly impossible to ask them not to use excel while running the macro.
    Thanks a lot for help!