How can I change a Modal Userform from Modal to Modeless at run time ? !

[Jaafar Tribak]

Hi all,

I am wondering if one can force a Modal UserForm to become Modeless after loading the UserForm.

Load the Userform as Modal => Click on a CommandButton on the Userform => The Userform now becomes Modeless.

Any ideas ?

Regards.

 

[Chris Macro]

Thank you for the updated code and links to documentation. I haven't had a chance to sit down and go through this yet (hopefully, will get some time next week), but will let you know if I run into issues. Really appreciate the help on this ZVI!!

 

[ZVI]

You are welcome, Chris. Links are just for VBA divers - happy diving to you!