|
交互界面如下
可手动选择练习模式“随机练习”OR“逐一练习”,默认“随机练习”
点击“选题”按钮可手动选择题目
在“这是问题”右侧出现问题
在“回答问题”右侧手动输入答案
点击“提示”出现问题的提示2秒
点击“OK”提交答案,并判定答案是否正确
点击“Cancel”退出练习
有以下代码实现按钮功能- Private Sub CommandButton1_Click()
- '点击OK,判定输入答案是否正确
- Call TST
- End Sub
- Private Sub CommandButton2_Click()
- '点击取消,停止做题
- UserForm1.Hide
- End Sub
- Private Sub CommandButton3_Click()
- '点击选题,可以进行随机选题或者按顺序答题
- Dim i As Long
- If UserForm1.OptionButton1.Value Then
- i = Worksheets("TEST").Cells(1, 1)
- i = Int((i * Rnd) + 1)
- UserForm1.TextBox1 = Worksheets("BOOK").Cells(i, 3).Value
- Else
- For i = 1 To Worksheets("TEST").Cells(1, 1)
- If Worksheets("BOOK").Cells(i, 3) = UserForm1.TextBox1.Value Then
- i = i + 1
- If i > Worksheets("TEST").Cells(1, 1) Then
- MsgBox ("Finish Testing!")
- i = 1
- Exit For
- End If
- Exit For
- End If
- Next i
- UserForm1.TextBox1 = Worksheets("BOOK").Cells(i, 3).Value
- End If
- End Sub
- Private Sub CommandButton4_Click()
- Dim i, newHour, newMinute, newSecond As Long
- Dim waitTime As String
- '点击提示,提示框出现答案2sec。
- newHour = Hour(Now())
- newMinute = Minute(Now())
- newSecond = Second(Now()) + 2
- waitTime = TimeSerial(newHour, newMinute, newSecond)
- For i = 1 To Worksheets("TEST").Cells(1, 1)
- If Worksheets("BOOK").Cells(i, 3) = UserForm1.TextBox1.Value Then
- UserForm1.TextBox3 = Worksheets("BOOK").Cells(i, 4)
- Application.Wait waitTime
- UserForm1.TextBox3 = ""
- Exit For
- End If
- Next i
- End Sub
复制代码 |
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
评分
-
查看全部评分
|