Forum Discussion
excel userform close error
Hi all, I have a user form that is called from the ThisWorkbook Module to run on startup the form works perfectaly until i try to close the form after the task is complete ive tried Both Unload ...
Which event you are utilizing on ThisWorkbook Module? Is it Workbook_Open event?
If yes, try to utilize Workbook_Activate event instead.
Also, if you want to close the UserForm, use Unload instead of Hide as Hide will not close the UserForm but hide it i.e. make it invisible and the UserForm will still be available in the memory.
Hi thanks for the repy i traced the error in the end it was the wrong types of quote around part of the loading module
No problem! Glad your issue has been resolved.