Running Userform & Compliling Data

[willowonyx]

I have a feeling I went backwards with all this because I am teaching myself how to use VB.

So, I was given a two sheet Excel 2003 workbook with questions to be asked via a survey. So I designed a user form (by hitting Alt+F11) from the sheets and built a user form that asks the exact questions on the sheets. It ended up being an 11 page multisheet user form (lots of questions and answers).

There are many text boxes, drop down list etc... in the user form.

What I need to do is two things.
First, how do I get the user form to open up when I send the file to someone? Right now, I "run" it and it pops up, I don't want them to see the excel sheets.
Second, after the person goes through the 11 pages and has entered/selected their answers, I need all that data to be compiled into a report. How is that done?

Any help or suggestions are greatly appreciated.

[royUK]

You need to either add a button or use the WorkBook_Open event to display the form

Please Login or Register  to view this content.

Workbook Event code should be added to the workbook code module:

Copy the Excel VBA code that you want to use
Select the workbook in which you want to store the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
Right-click on the ThisWorkbook object, and choose View Code
Where the cursor is flashing, choose Edit | Paste

The entries need to be saved to the workbook, but you need to be more specific about how you want to save them

See the DatabaseForm example