Excel VBA User List

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Are you saying when the workbook opens users have to to select 4 values. The values will have to be selected rather than being typed ?