Set ShowModal to False in userform initialize event

[YasserKhalil]

Hello everyone
I know that the userform can be showed using such a line

Code: Select all

IUserForm1.Show vbModeless

This will solve the problem. But I would like to know if it is possible to set the showmodal to False in the userform_initialize event or not?

[Guessed]

Yes, you can hide it and re-show it to apply a modal/modeless switch.

See https://www.mrexcel.com/board/threads/h ... me.408356/

[YasserKhalil]

Thanks a lot.