|
楼主 |
发表于 2022-5-17 15:16
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Private Sub save()
- Dim erow&, i&
- Dim Arr0, brr
-
- With Worksheets("sheet1")
- If Worksheets("Sheet1").Rows.Hidden = True Then
- Worksheets("Sheet1").Rows.Hidden = False
- End If
- End With
-
- Worksheets("Sheet1").Select
-
- With Worksheets("Sheet1")
- If ComboBox1.Value = blank Then
- MsgBox "未选择人员"
- Exit Sub
- End If
-
- If DTPicker1.Value = blank Then
- MsgBox "未选择日期"
- Exit Sub
- End If
-
- erow = .Range("A" & Rows.Count).End(xlUp).Row + 1 ' 取得最后一个非空单元格行数。为了不覆盖表头,+1去掉表头行
- If erow = 2 Then
- Else
- brr = .Range("A1:A" & erow - 1)
- 'Debug.Print brr
- For i = 1 To UBound(brr)
- If brr(i, 1) = TextBox1.Text Then
- MsgBox (" 此日期的人员已经登记 ")
- Exit Sub
- End If
- Next i
- End If
-
- .Cells(erow, "A").Value = ComboBox1.Value
- .Cells(erow, "B").Value = DTPicker1.Value
- Arr0 = .Range("C2:C" & erow)
- End With
-
- With Me.ListBox1
- .ColumnCount = 1
- .BackColor = &HFFFF00
- .ColumnWidths = "80"
- '.List = Arr0
- End With
- ComboBox1 = ""
- TextBox1.Text = ""
- TextBox2.Text = ""
- OptionButton1.Value = False
- OptionButton2.Value = False
- OptionButton3.Value = False
- OptionButton4.Value = False
- CreateList
- Worksheets("Manual").Select
- ThisWorkbook.save
-
- End Sub
复制代码 |
|