Hi everyone!
What do I cod instead of Range("L5").Value2 = ComboBox3.Value
Based on the selection in the combobox 3 it populate the cell “L5” with the contents of combobox 3, but what I want it to do is to populate a number that is name ranged to the selection in the combobox 3.
Combobox 3 selection is green but I would send 40 to the cell “L5”?
What do I cod instead of Range("L5").Value2 = ComboBox3.Value
Based on the selection in the combobox 3 it populate the cell “L5” with the contents of combobox 3, but what I want it to do is to populate a number that is name ranged to the selection in the combobox 3.
Combobox 3 selection is green but I would send 40 to the cell “L5”?
Code:
Sub WorkSheet_Activate()
Worksheets(1).OLEObjects("ComboBox1").ListFillRange = "Data"
ComboBox1.ListIndex = 0
End Sub
Private Sub ComboBox1_Change()
Me.ComboBox2.Value = ""
Me.ComboBox2.ListFillRange = Me.ComboBox1.Value
End Sub
Private Sub ComboBox2_Change()
Me.ComboBox3.Value = ""
Me.ComboBox3.ListFillRange = Me.ComboBox2.Value
End Sub
Private Sub ComboBox3_Change()
Range("L5").Value2 = ComboBox3.Value