How to use Excel while VBA userform is open?

Question

How do I make it so I can still use Excel (use worksheets and enter data into cells) while a vba userform is open?

Right now, once my userform is open I can't use anything else on Excel until the form is closed.

joestott1 · Accepted Answer

Userforms can be open in two states:

vbModal takes full control over Excel and won't allow input any worksheet window until the userform is closed.

vbModeless opens the userform window but still allows user to interact with any open worksheets and other Excel functions.

In your case, to fix your problem - open your userform using vbModeless.

Sub OpenUserform()

    Userform.Show vbModeless

End Sub

Hope this helps.

[Solved] How to use Excel while VBA userform is open?