I need to display a form as Modal but upon the button click on that form I need it to switch to modaless.

I was thinking displaying it modaless and have the parent form loop until a process is complete but it would be easier to just switch states instead if possible.

Note: This is a VBA UserForm but I can convert any solution to VBA.

Thanks