|
- Private Sub CommandButton4_Click()
- '是否导入名次数据
- Dim bl As Boolean
- '错误处理
- On Error GoTo ErrorHandler
-
- bl = MsgBox("是否导入名次数据", vbInformation + vbYesNo) = vbYes
-
- '判断成绩栏是否都有填完整
- For i = 1 To 8
- If Len(Controls("TextBox" & i).Text) = 0 Then
- MsgBox " 成绩栏不能为空!", vbOKOnly, " 系统提示": Exit Sub
- End If
- Next i
- '如果导入名次数据,判断所有的成绩栏数据是否填完整
- If bl Then
- For i = 9 To 16
- If Len(Controls("TextBox" & i).Text) = 0 Then
- MsgBox " 名次栏不能为空!", vbOKOnly, " 系统提示": Exit Sub
- End If
- Next
- End If
-
- '写入数据
- With Sheet2
- .[a2].Value = TextBox1.Value
- .[a3].Value = TextBox2.Value
- .[a4].Value = TextBox3.Value
- .[a5].Value = TextBox4.Value
- .[a6].Value = TextBox5.Value
- .[a7].Value = TextBox6.Value
- .[a8].Value = TextBox7.Value
- .[a9].Value = TextBox8.Value
- If bl Then
- .[b2].Value = TextBox9.Value
- .[b3].Value = TextBox10.Value
- .[b4].Value = TextBox11.Value
- .[b5].Value = TextBox12.Value
- .[b6].Value = TextBox13.Value
- .[b7].Value = TextBox14.Value
- .[b8].Value = TextBox15.Value
- .[b9].Value = TextBox16.Value
- End If
- End With
- MsgBox "导入完成"
- Exit Sub
- '容错处理
- ErrorHandler:
- MsgBox Err.Number & vbCrLf & _
- Err.Description
- End Sub
复制代码 |
|