Dim x, iPrivate Sub Form_Load()line: x = Int(Val(InputBox("设定提醒时间间隔:", "数据输入"))) If x < 1 Then GoTo line Label1.Caption = "设定提醒时间间隔为" & x & "分钟" i = 0 End Sub Private Sub Timer1_Timer() Label2.Caption = Time i = i + 1 Debug.Print i a = i Mod (60 * x) If a = 0 Then MsgBox Time & " "& "该保存数据库了""" End If End Sub
读取设置数据,相应设置Timer控件的属性,在Timer事件中写显示提示的代码
x = Int(Val(InputBox("设定提醒时间间隔:", "数据输入")))
If x < 1 Then GoTo line
Label1.Caption = "设定提醒时间间隔为" & x & "分钟"
i = 0
End Sub
Private Sub Timer1_Timer()
Label2.Caption = Time
i = i + 1
Debug.Print i
a = i Mod (60 * x)
If a = 0 Then
MsgBox Time & " "& "该保存数据库了"""
End If
End Sub