hello
I have UserForm, when I open another Excel file and then close it, UserForm closes automatically. Is there a code I add to UserForm that prevents it from being closed when I close another Excel file?
thank you
hello
I have UserForm, when I open another Excel file and then close it, UserForm closes automatically. Is there a code I add to UserForm that prevents it from being closed when I close another Excel file?
thank you
Welcome to VBAX azizis4. Can you post your code so we can see what you currently have?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
I did not make a code for that, I want a code for that if possible, when I close another excel file, I do not want the userform to close with it
Have a look at the concept of making the Userform modeless
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
i tried to make a showmodal in the properties True and Fulse , but it did not work in the both way, I expect a bug in Excel 2016, unless there is code to solve this problem.
Have a look here, and make sure you read through to the bottom of the page to understand. Hopefully this will give you some ideas to try. https://excelmacromastery.com/vba-userform/
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link