Private Sub UserForm_Activate() i = Format(Now(), "hh:mm:ss") Do Until False DoEvents x = Format(Now(), "hh:mm:ss") DoEvents If TimeValue(x) > TimeValue(i) + TimeValue("00:00:10") Then UserForm1.Hide End End If Loop End Sub ***********************************
|
联系客服