View original (French)

Open the userform for 5 seconds

Solved
judoka15 -  
 judoka15 -
Hello,
How to make a userform open only for 5 seconds in Excel
What is the VBA code
please

Thank you
Configuration: Windows XP Internet Explorer 7.0

2 answers

  1. judoka15
     
    Thank you very much
    This is exactly what I wanted
    Thanks again
    2
  2. pilas31 Posted messages 1878 Status Contributor 648
     
    Hello,

    An idea for a solution... Suppose its name is Userform1..

    In the code associated with Userform1, put:

    Private Sub UserForm_Activate() temps = Now + TimeValue("00:00:05") Application.OnTime temps, "finir" End Sub

    with the following macro "finir" (in a module):

    Sub finir() UserForm1.Hide End Sub

    Best regards,
    -1