(A userform loaded with the Load statement is not visible until you use the Show method) and when you switch between userforms. The Activate and Deactivate events only occur when the focus is moved within the application. Moving the focus to another application will not trigger these events.
Jun 03, 2011 · Where the cursor is flashing, type a line that opens the UserForm. In this example, the UserForm is named frmParts, so type the following line of code in the Workbook_Open event: frmParts.Show; Test the Workbook_Open Code. To test the Workbook_Open code, follow these steps: Save and close the UserForm workbook.