PDA

View Full Version : Sleeper: User form help



austenr
11-06-2004, 10:01 AM
I know I have seen this somewhere on the board before but I cannot find it. I have a user form. How do you get it to pop up when the file is first opened? Then the user can read it and proceed. Thanks in advance for everyones excellent help.

TonyJollans
11-06-2004, 10:46 AM
You need to put code to show it in the Workbook_Open event.

In the VBE, open the ThisWorkbook module in the workbook. In the left dropdown at the top (where it says (General)), change it to Workbook and the default Open will be selected from the right dropdown and a Workbook_Open procedure will appear. Just code your UserForm.Show in there.