I am creating a spreadsheet for our Sales Reps to use to calculate their commissions. In this spreadsheet, there are several drop-down lists that they can select from. For Example:
Order Type: Commercial, Government, State
Sales Type: Standard, Promotional, Government
Maintenance: None, Premier, Standard
I'm worried that they will just re-use the sheet for each sale and forget to change the drop-down lists back to their standard settings. I would like to create a Macro, that I can assign to a text box, that will select a specific thing in each list when it is run. For example:
Order Type: Commercial
Sales Type: Standard
Maintenance: None
Is this possible? When I try to record myself doing this, it doesn't seem to take.
Thanks!
