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.

2 total posts (Page 1 of 1)  
| 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.....

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums