General discussion

  • Creator
    Topic
  • #2074506

    Displaying Forms

    Locked

    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.

All Comments

  • Author
    Replies
    • #3777125

      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

Viewing 0 reply threads