Forum Discussion

Jai Bohl's avatar
Jai Bohl
Copper Contributor
Mar 22, 2018

Macro - Select Items in Dropdown Lists

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!

No RepliesBe the first to reply

Resources