|
删除记录代码如下
- Private Sub CommandButton10_Click()
- With Sheet3
- .Rows(Rnumber).Delete Shift:=xlUp
- End With
- End Sub
复制代码
保存修改代码如下- Private Sub CommandButton9_Click() '修改
- '
- ' Sheet1.Range("B" & hh) = Me.学员电话
- ' Sheet1.Range("J" & hh) = Me.课程名称
- ' Sheet1.Range("K" & hh) = Me.实缴学费
- ' Sheet1.Range("L" & hh) = Me.返学费
- '
- '' Unload Me
- '
- With Sheet1.Rows(Rnumber)
- .Resize(, 2).Value = Array(Date & " " & Time, Me.学员电话)
- .Columns(10).Resize(, 3) = Array(Me.课程名称, Me.实缴学费, Me.返学费)
- End With
- MsgBox "修改报名信息成功!!!", 48, "温馨提示……"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|