Private Sub ComboBox1_Change()
Select Case Me.ComboBox1.Value
Case "ARA"
Me.ComboBox1.BackColor = 5
Case "BFC"
Me.ComboBox1.BackColor = 6
Case "BRE"
Me.ComboBox1.BackColor = 7
Case "COR"
Me.ComboBox1.BackColor = 8
Case "CVL"
Me.ComboBox1.BackColor = 9
Case "GES"
Me.ComboBox1.BackColor = 10
Case "HDF"
Me.ComboBox1.BackColor = 11
Case "IDF"
Me.ComboBox1.BackColor = 12
Case "NOR"
Me.ComboBox1.BackColor = 13
Case "NAQ"
Me.ComboBox1.BackColor = 14
Case "OCC"
Me.ComboBox1.BackColor = 15
Case "PDL"
Me.ComboBox1.BackColor = 16
Case Else
Me.ComboBox1.BackColor = 17
End Select
End Sub