hi,
i have a userform and i want to set it if user click close, it will unload the userform but if user didnt close or the userform is idle for 1min, the userform will automatically close.
i have try this
Private Sub UserForm_Activate()
startTimer = Timer
Do While Timer < (startTimer + 60)
DoEvents
Loop
Unload Me
End Sub
and at every button in userform i try this
Private Sub ComboBoxx4_Change()
startTimer = Timer
End sub
Sub CommandButton1_Click()
'close button
startTimer = Timer
Unload Me
End Sub
but the codes doesnt work.it will close in 1 min even the userform is not idle.
Bookmarks