|
呵呵,看楼主急成这个样子,今天是端午节了,大家都过节去了, 请楼主验证 效果在附件里- Sub 时间()
- UserForm1.TextBox1 = Left(Application.WorksheetFunction.Text(Now(), "HH:MM"), 2)
- UserForm1.TextBox2 = Right(Application.WorksheetFunction.Text(Now(), "HH:MM"), 2)
- UserForm1.TextBox3 = Right(Application.WorksheetFunction.Text(Now(), "MM:SS"), 2)
- Application.OnTime Now() + TimeValue("00:00:01"), "时间"
- End Sub
- Sub 停止()
- On Error Resume Next
- Application.OnTime Now() + TimeValue("00:00:01"), "时间", , False
- End Sub
复制代码- Private Sub CommandButton1_Click()
- Call 停止
- End Sub
- Private Sub CommandButton2_Click()
- Call 时间
- End Sub
- Private Sub UserForm_Initialize()
- Call 时间
- End Sub
复制代码- Private Sub Workbook_Open()
- UserForm1.Show
- End Sub
复制代码
[ 本帖最后由 佛山小老鼠 于 2011-6-7 02:53 编辑 ] |
|