hotopf.blogg.se

Show in the macro that is used to show the form. You do not have to put any additional code within the code section for the UserForm itself merely add vbModeless after. In this example, this code is contained within a module and looks like this: Sub ShowUserForm() You put this after the line that you use to display the form. VbModeless is what tells Excel to make the form Modeless. How to Make a Modless Form with Code UserForm1.Show vbModeless

VBA Window (Alt+F11) > Select the UserForm > Look to the Properties window (F4) > Change the ShowModal property to False. Here, you will learn how to make Modeless UserForms, which will include how to do it with and without VBA. This means that you can select cells, enter data, move to other worksheets, run new macros, and do everything you would normally do in Excel, all while the form is open and visible.īy default, UserForms are Modal, which means that when they are open you cannot do anything else in Excel except to interact with that form this also means that no macros will run unless initiated by the form that is visible. Modeless UserForms allows you to interact with Excel while the form is open and visible.