10 2016 档案

迟到不了的excel VB宏
摘要：Private Sub CommandButton1_Click() 列修改前 = "C" 列修改后 = "D" 列注释 = "E" Dim 上班时间 As Date 上班时间 = "09:00:00" Dim i As Integer For i = 2 To 33 If Cells(i, 列修改前) > 上班时间 Then Cells(i, 列修改后) = FormatDateTime(上班... 阅读全文
posted @ 2016-10-31 00:52 龙鸿轩 阅读(219) 评论(0) 推荐(0)