It looks like you're new here. If you want to get involved, click one of these buttons!
Hi Matt,You are right about the timer. The only thing is, a timer has a limit of 1 minute.so you either have to use two timers with the second one disabled, and use the first one to enable the second one, or create a routine like I did hear, but in both cases, you would not be able to go over two minutes.If you want to go over two minutes, then you would have to do something different like maybe more than two timers.
Here is an example a how to do it using a public variable:
Public UnloadValue As Boolean
Private Sub Timer1_Timer()If UnloadValue = False Then UnloadValue = True Exit SubEnd IfUnload Me
Set the timer interval to 60000
Static TimerCount As IntegerTimerCount = TimerCount + 1If TimerCount = 5 Then Unload Me