Vba Form Active. If no form or subform has the focus when you use the activeform property an error occurs. The first step is to enter the visual basic editor form the ribbon or by pressing the alt f11 buttons.
Activate event for userform1 private sub userform activate userform1 caption click my client area end sub click event for userform1 private sub userform click load userform2 userform2 startupposition 3 userform2 show end sub deactivate event for userform1 private sub userform deactivate userform1 caption i just lost the. You can make a form active by opening it by choosing it or a control on it or by using the setfocus method in visual basic. 2 minutes to read.
If a subform has the focus activeform refers to the main form.
Expression a variable that represents a form object. Activate event for userform1 private sub userform activate userform1 caption click my client area end sub click event for userform1 private sub userform click load userform2 userform2 startupposition 3 userform2 show end sub deactivate event for userform1 private sub userform deactivate userform1 caption i just lost the. Step 3 then right click on the command button and select option view code. Step 1 navigate to vba window by pressing alt f11 and navigate to insert menu and select user form.
