Private Sub ComboBox1_GotFocus() ComboBox1.Clear ComboBox2.Clear ComboBox3.Clear ARR1 = Array("优良", "满意", "合格") For I = 0 To UBound(ARR1) ComboBox1.AddItem ARR1(I) ComboBox2.AddItem ARR1(I) ComboBox3.AddItem ARR1(I) Next End Sub
Private Sub ComboBox1_GotFocus() ComboBox1.Clear ComboBox2.Clear ComboBox3.Clear ARR1 = Array("优良", "满意", "合格") For I = 0 To UBound(ARR1) ComboBox1.AddItem ARR1(I) ComboBox2.AddItem ARR1(I) ComboBox3.AddItem ARR1(I) Next End Sub