Search

Web Development

General discussion

Gravatar
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.

2 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| 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
2 total posts (Page 1 of 1)  

Start or search

Related Discussions

Related Forums