Web Development

General discussion

Locked

Displaying Forms

By matthew.done ·
Hi,
Does anyone know some code for use in VBA that can get a form to stay visible for a set amount of time and then hide itself once it steps out of the timer loop. Any help would be great.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Displaying Forms

by LyXX In reply to Displaying Forms

Place on form Timer from advanced controls.
Setup Timer interval as You need.
And Insert this code:

Private Sub IeTimer1_Timer()
Me.Hide
Me.IeTimer1.Enabled = ValFalse
End Sub

Private Sub UserForm_Activate()
Me.IeTimer1.Enabled = ValTrue
End Sub

Collapse -

Displaying Forms

by matthew.done In reply to Displaying Forms

You are the best! Thanks.....

Related Discussions

Related Forums