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

Hi Shinka

You can build a string like this and use that in the save line

Dim str As String
With Sheets("Sheet1")
str = .ComboBox1.Value & .ComboBox2.Value & .Range("C15")
End With
MsgBox str


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Shinka" wrote in message ...
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

Thanks Ron. I'm also using parts of your e-mail macros.
You've been a great help, thanks.

"Ron de Bruin" wrote:

Hi Shinka

You can build a string like this and use that in the save line

Dim str As String
With Sheets("Sheet1")
str = .ComboBox1.Value & .ComboBox2.Value & .Range("C15")
End With
MsgBox str


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Shinka" wrote in message ...
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

You are welcome

Thanks for the feedback

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Shinka" wrote in message ...
Thanks Ron. I'm also using parts of your e-mail macros.
You've been a great help, thanks.

"Ron de Bruin" wrote:

Hi Shinka

You can build a string like this and use that in the save line

Dim str As String
With Sheets("Sheet1")
str = .ComboBox1.Value & .ComboBox2.Value & .Range("C15")
End With
MsgBox str


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Shinka" wrote in message ...
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