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.
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.
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.
Enjoy,
Tony
---------------------------------------------------------------
Give a man a fish and he'll eat for a day.
Teach him how to fish and he'll sit in a boat and drink beer all day.
I'm (slowly) building my own site: www.WordArticles.com