How can a user enter data on a worksheet or document, or switch windows, while UserForm1 is displayed on the screen?
Show the form with this statement: UserForm1.Show vbModal.
Set the user form's SpecialEffect property to frmShowModal.
Include this statement in the code: UserForm1.Hwnd = False.
UserForm1.Hwnd = False.
Set the user form's ShowModal property to False.