Select Case RS!lecode
Case 0
If Level0(i) > 0 Then
'检查本章试题是否已选够
For n = 0 To UBound(zj(n))
If cmbChapter(i).AddItem(n) = RS!unit Then Exit For
Next
If Chapter(i, n) > 0 Then
wo.Books("h2").Range.Text = " & j & "" 、"" & RS!stdes & " & vbCrLf
j = j + 1
Chapter(i, n) = Chapter(i, n) - 1
Level0(i) = Level0(i) - 1
Count(i) = Count(i) - 1
End If
Case 1 '<---case 提示没 select case
If Level1(i) > 0 Then
'检查本章试题是否已选够
For n = 0 To UBound(zj(n))
If cmbChapter(i).AddItem(n) = RS!unit Then Exit For
Next
If Chapter(i, n) > 0 Then
wo.Books("h2").Range.Text = " & j & "" 、"" & RS!stdes & " & vbCrLf
j = j + 1
Chapter(i, n) = Chapter(i, n) - 1
Level1(i) = Level1(i) - 1
Count(i) = Count(i) - 1
End If
Case 2
If Level2(i) > 0 Then
'检查本章试题是否已选够
For n = 0 To UBound(zj(n))
If cmbChapter(i).AddItem(n) = RS!unit Then Exit For
Next
If Chapter(i, n) > 0 Then
wo.Books("h2").Range.Text = " & j & ""、"" & RS!stdes & " & vbCrLf
j = j + 1
Chapter(i, n) = Chapter(i, n) - 1
Level2(i) = Level2(i) - 1
Count(i) = Count(i) - 1
End If
End Select
解决方案 »
- 为什么会溢出?
- 求助:关于通过时间序列模型进行预测的程序
- 急!如果在VB中将从SQL中查询(按某些条件)出来的数据集导出成EXCEL文件...(在线等,成功马上结贴)
- 用setup factory打包工具是如何调用他的Uninstall删除程序呢?
- 网页注册的控件能否取到调用网页里的函数?
- add this project to sourcesafe?
- 如何将recordset记录直接保存到Access数据库中?
- 有关取文本的宽度,请进
- 请问recordset,tabledef有什么区别?请详细点,高分
- 如何动态的改变MSHFlexGrid的行和列,并在固定行和固定列上加上序列号
- VB问题,用enumwindows枚举窗口的顺序问题
- access备注型问题
If Level0(i) > 0 Then
'检查本章试题是否已选够
For n = 0 To UBound(zj(n))
If cmbChapter(i).AddItem(n) = RS!unit Then Exit For
Next
If Chapter(i, n) > 0 Then
wo.Books("h2").Range.Text = " & j & "" 、"" & RS!stdes & " & vbCrLf
j = j + 1
Chapter(i, n) = Chapter(i, n) - 1
Level0(i) = Level0(i) - 1
Count(i) = Count(i) - 1
End If
end if
Case 1 '<---case 提示没 select case
Case 0
If Level0(i) > 0 Then
'检查本章试题是否已选够
For n = 0 To UBound(zj(n))
If cmbChapter(i).AddItem(n) = RS!unit Then Exit For
Next
If Chapter(i, n) > 0 Then
wo.Books("h2").Range.Text = " & j & "" 、"" & RS!stdes & " & vbCrLf
j = j + 1
Chapter(i, n) = Chapter(i, n) - 1
Level0(i) = Level0(i) - 1
Count(i) = Count(i) - 1
End If
End If
Case 1 '<---case 提示没 select case
If Level1(i) > 0 Then
'检查本章试题是否已选够
For n = 0 To UBound(zj(n))
If cmbChapter(i).AddItem(n) = RS!unit Then Exit For
Next
If Chapter(i, n) > 0 Then
wo.Books("h2").Range.Text = " & j & "" 、"" & RS!stdes & " & vbCrLf
j = j + 1
Chapter(i, n) = Chapter(i, n) - 1
Level1(i) = Level1(i) - 1
Count(i) = Count(i) - 1
End If
End If
Case 2
If Level2(i) > 0 Then
'检查本章试题是否已选够
For n = 0 To UBound(zj(n))
If cmbChapter(i).AddItem(n) = RS!unit Then Exit For
Next
If Chapter(i, n) > 0 Then
wo.Books("h2").Range.Text = " & j & ""、"" & RS!stdes & " & vbCrLf
j = j + 1
Chapter(i, n) = Chapter(i, n) - 1
Level2(i) = Level2(i) - 1
Count(i) = Count(i) - 1
End If
End If
End Select
If Level0(i) > 0 Then
'检查本章试题是否已选够
For n = 0 To UBound(zj(n))
If cmbChapter(i).AddItem(n) = RS!unit Then Exit For
Next
If Chapter(i, n) > 0 Then
wo.Books("h2").Range.Text = " & j & "" 、"" & RS!stdes & " & vbCrLf
j = j + 1
Chapter(i, n) = Chapter(i, n) - 1
Level0(i) = Level0(i) - 1
Count(i) = Count(i) - 1
End If
Case 1 '<---case 提示没 select case
少了一个end if