How to use Excel wh...
 
Notifications
Clear all

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

1 Posts
2 Users
2 Likes
116 Views
0
Topic starter

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.

1 Answer
2

Userforms can be open in two states:

  1. vbModal
  2. vbModeless

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.

 

 

Share: