Morning all,
Can anyone help?
My case argument has a compile error, probably due to my naming of the case. Unfortunately, I've got a common title of "STANDARD"
but the variables change throughout every case. Any ideas?
Private Sub ComboBox3_Change()
Select Case Me.ComboBox3.Value
Case "STANDARD"
If ComboBox4.Value = "160x35" Then
Me.ComboBox26.Value = "409272.005"
Me.ComboBox27.Value = "409272.005"
Case "STANDARD"
If ComboBox4.Value = "200x50" Then
Me.ComboBox26.Value = "520079.004"
Me.ComboBox27.Value = "520079.004"
Case "STANDARD"
If ComboBox4.Value = "250x40" Then
Me.ComboBox26.Value = "13479.12"
Me.ComboBox27.Value = "13479.12"
Case "UNBRAKED"
If ComboBox4.Value = "250x40" Then
Me.ComboBox26.Value = ""
Me.ComboBox27.Value = ""
End If
End Select
End Sub
Bookmarks