I am trying to write a macro that saves the file to a network folder whos
filename is based on what is selected in 2 combo boxes and a 3rd cell which
has the date. Example:

Combo Box 1 = Unit Process:
Please Select
Sub Assy Repair
Sub Assy Test
Assembly
Final Test
Quality Assurance

Combo Box 2 = Station:
Please Select
Sub Assy Repair
Sub Assy Test
Assembly
Final Test
Quality Assurance

Date:
Cell C15

Is there a shorter way to do this then using If Then statements?

Thanks