你这一段宏里没有设定“销售查询”,当然时间内容不会变啦!
Private Sub CommandButton1_Click()
If ComboBox1.Value = "产量查询" And ComboBox2.Value = "第三生产线" And ComboBox3.Value = "普通白玻" Then
i = "三线白玻"
j = "生产时间"
UserForm1.Caption = "玻璃产销存系统--" + ComboBox2.Value + "--" + ComboBox3.Value + "查询界面"
list
ElseIf ComboBox1.Value = "产量查询" And ComboBox2.Value = "第三生产线" And ComboBox3.Value = "超白" Then
i = "三线超白"
j = "生产时间"
UserForm1.Caption = "玻璃产销存系统--" + ComboBox2.Value + "--" + ComboBox3.Value + "查询界面"
list
ElseIf ComboBox1.Value = "产量查询" And ComboBox2.Value = "第四生产线" And ComboBox3.Value = "普通白玻" Then
i = "四线白玻"
j = "生产时间"
UserForm1.Caption = "玻璃产销存系统--" + ComboBox2.Value + "--" + ComboBox3.Value + "查询界面"
list
End If
End Sub
应该设置新的 j 值!