清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
Private Sub Form_Load() '控制界面大小 Me.Height = 5820 Me.Width = 7080 End Sub Private Sub Label_calculate_Click() '判断并机算时间 '清空时间记录 Label.Caption = "" '判断输入框的多种情况 If Text_bTime.Text = "" And Text_sTime.Text = "" Then MsgBox "您还没有输入时间,请输入时间!" '把光标移到开始时间的输入框 Text_bTime.SetFocus ElseIf Text_bTime.Text = "" And Text_sTime.Text <> "" Then If IsDate(Text_sTime.Text) = True Then MsgBox "您还没有输入开始时间,请输入!" '把光标移到开始时间的输入框 Text_bTime.SetFocus Else MsgBox "您还没有输入开始时间,请输入!并且截止时间格式错误,格式为:" & Now Text_bTime.SetFocus Text_sTime.Text = "" End If ElseIf Text_bTime.Text <> "" And Text_sTime.Text = "" Then If IsDate(Text_bTime.Text) = False Then MsgBox "您输入的开始时间不是时间格式,请输入时间格式,格式为:" & Now '清空输入框 Text_bTime.Text = "" '把光标移到开始时间的输入框 Text_bTime.SetFocus Else MsgBox "您没有输入截止时间,默认此时为截止时间。" '调用机算过程 Call r_Times End If ElseIf IsDate(Text_bTime.Text) = False And IsDate(Text_sTime.Text) = False Then MsgBox "您输入格式错误,格式如:" & Now '清空输入框 Text_bTime.Text = "" Text_sTime.Text = "" '把光标移到开始时间的输入框 Text_bTime.SetFocus ElseIf IsDate(Text_bTime.Text) = True And IsDate(Text_sTime.Text) = True Then '调用机算过程 Call j_Times ElseIf IsDate(Text_bTime.Text) = False And IsDate(Text_sTime.Text) = True Then MsgBox "您输入的开始时间有误,请重新输入!" Text_bTime.Text = "" Text_bTime.SetFocus ElseIf IsDate(Text_bTime.Text) = True And IsDate(Text_sTime.Text) = False Then MsgBox "您输入的截止时间有误,请重新输入!" Text_sTime.Text = "" Text_sTime.SetFocus Else MsgBox "您的输入有误,请重新输入!" '清空输入框 Text_bTime.Text = "" Text_sTime.Text = "" '把光标移到开始时间的输入框 Text_bTime.SetFocus End If End Sub Public Sub r_Times() '如果没有输入截止时间时,默认此时为截止时间 Label.Caption = "到此时相隔:" & DateDiff("yyyy", Text_bTime.Text, Now) & "年" & Chr(10) Label.Caption = Label.Caption & DateDiff("q", Text_bTime.Text, Now) & "季节" & Chr(10) Label.Caption = Label.Caption & DateDiff("m", Text_bTime.Text, Now) & "月" & Chr(10) Label.Caption = Label.Caption & DateDiff("ww", Text_bTime.Text, Now) & "周" & Chr(10) Label.Caption = Label.Caption & DateDiff("d", Text_bTime.Text, Now) & "天" & Chr(10) Label.Caption = Label.Caption & DateDiff("h", Text_bTime.Text, Now) & "小时" & Chr(10) Label.Caption = Label.Caption & DateDiff("n", Text_bTime.Text, Now) & "分钟" & Chr(10) Label.Caption = Label.Caption & DateDiff("s", Text_bTime.Text, Now) & "秒" End Sub Public Sub j_Times() '机算时间 Label.Caption = "相隔:" & DateDiff("yyyy", Text_bTime.Text, Text_sTime.Text) & "年" & Chr(10) Label.Caption = Label.Caption & DateDiff("q", Text_bTime.Text, Text_sTime.Text) & "季节" & Chr(10) Label.Caption = Label.Caption & DateDiff("m", Text_bTime.Text, Text_sTime.Text) & "月" & Chr(10) Label.Caption = Label.Caption & DateDiff("ww", Text_bTime.Text, Text_sTime.Text) & "周" & Chr(10) Label.Caption = Label.Caption & DateDiff("d", Text_bTime.Text, Text_sTime.Text) & "天" & Chr(10) Label.Caption = Label.Caption & DateDiff("h", Text_bTime.Text, Text_sTime.Text) & "小时" & Chr(10) Label.Caption = Label.Caption & DateDiff("n", Text_bTime.Text, Text_sTime.Text) & "分钟" & Chr(10) Label.Caption = Label.Caption & DateDiff("s", Text_bTime.Text, Text_sTime.Text) & "秒" & Chr(10) End Sub