Delay in msgbox 1

[osi2301]

I have a msgbox that I want to display when opening a form. I don't want the msgbox to display immediately upon opening. I want a delay of about 5 seconds.

I insert the TIMER INTERVAL of 5000 and place the msgbox in TIMER EVENT. Then when I open the form it waits five seconds before displaying the message but then keeps displaying it every five seconds in a closed loop. How do I make it fire only once?

 

[ZmrAbdulla]

Set it by code
When open timer interval = 5 seconds

Private Sub Form_Open(Cancel As Integer)
Me.TimerInterval = 5000
End Sub

Then on time dispaly message and disable the timer

Private Sub Form_Timer()
MsgBox "hello"
Me.TimerInterval = 0
End Sub

________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.