|
发表于 2013-6-21 13:28
|
显示全部楼层
本楼为最佳答案
- Private Sub CommandButton4_Click()
- '是否导入名次数据
- Dim bl As Boolean
- '错误处理
- On Error GoTo ErrorHandler
- '判断成绩栏是否都有填完整
- For i = 1 To 8
- If Len(Controls("TextBox" & i).Text) Then Exit For
- Next i
- If i = 9 Then MsgBox " 成绩栏不能为空!", vbOKOnly, " 系统提示": Exit Sub
- '如果导入名次数据,判断所有的成绩栏数据是否填完整
- For i = 9 To 16
- If Len(Controls("TextBox" & i).Text) Then Exit For
- Next
- bl = True
- If i = 17 Then
- bl = MsgBox("名次数据有空值,是否导入名次数据", vbInformation + vbYesNo) = vbYes
- End If
- '写入数据
- With Sheet2
- For i = 1 To 8
- .Cells(i + 1, 1).Value = Me.Controls("TextBox" & i).Value
- Next
- If bl Then
- For i = 9 To 16
- .Cells(i - 7, 2).Value = Me.Controls("TextBox" & i).Value
- Next
- Else
- .Range("b2:b9").ClearContents
- End If
- End With
- MsgBox "导入完成"
- Exit Sub
- '容错处理
- ErrorHandler:
- MsgBox Err.Number & vbCrLf & _
- Err.Description
- End Sub
复制代码 |
|