randomize cycle and time useform

[mramoxia]

Hi,

I've got the following code to randomize through userforms, however I would like it to loop through on a random time frame from 5 minutes to 15 minutes and show for 5 seconds then close.

So just say I click the button to start the macro, it shows a random userform for 5 seconds then closes, then in say 8 minutes it brings up another userform for 5 seconds then closes and so on..

Sub TestMe2()Randomize
UserForms.Add "UserForm" & (Int(5 * Rnd) + 1)
UserForms(UserForms.Count - 1).Show


End Sub

Cheers