Excel VBA User List

Hi.

I would like to create an excel spreadsheet that opens up to a dialog box where the user has to enter in 4 different values.

For example, the user needs to enter the following:

- Class Major (choose from a list of 5 values)
- Class Code (choose from a list of 2 values)
- Class Length (choose from a list of 10 values)
- Class Group (can enter a value between 20 and 35)

I already have the list created for the items above.

Once the data is entered, I would like the user directed to another worksheet where all my calculation will display based on the user's entries.

I would like this created in VBA.

Please assist.

Thank you
Joseph