Web Development

General discussion

Gravatar
0 Votes
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

gravatar
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

gravatar
Collapse -

Displaying Forms

by matthew.done In reply to Displaying Forms

You are the best! Thanks.....

Back to Web Development Forum

Start or search

Related Discussions

Related Forums