|
当我点击这个按钮时会出现 错误424,无法进入本科生界面,但是为啥其他的研究生、实验室、科研界面可以进入
为何ben画了黄线,但是其他的yan,ke,shi都没有黄线
- Private Sub UserForm_Initialize()
- a = Application.WorksheetFunction.CountA(Sheets("本科生教学工作量").Range("C3:C6"))
- For b = 1 To a
- ComboBox5.AddItem Sheets("本科生教学工作量").Cells(b + 2, 3)
- Next b
- c = Application.WorksheetFunction.CountA(Sheets("本科生教学工作量").Range("D9:D21"))
- ' For d = 1 To c
- ' ComboBox6.AddItem Sheets("本科生教学工作量").Cells(d + 8, 4)
- ' Next d
- e = Application.WorksheetFunction.CountA(Sheets("本科生教学工作量").Range("E25:E32"))
- For f = 1 To e
- ComboBox8.AddItem Sheets("本科生教学工作量").Cells(f + 24, 5)
- Next f
- g = Application.WorksheetFunction.CountA(Sheets("本科生教学工作量").Range("F35:F40"))
- For h = 1 To g
- ComboBox10.AddItem Sheets("本科生教学工作量").Cells(h + 34, 6)
- Next h
- End Sub
复制代码ben窗体初始化事件中注释掉关于ComboBox6控件的这几句代码就可以进入本科生界面
|
|