Show Popup Box For x Seconds On Workbook Open`

  • is there a way to put a time delay on a pop up box - like show a pop up box for like 2 seconds when the file is opened?

  • Re: Time Delay Pop Up Box


    when i try to run the wait command with a user form the wait will not occour until after the user form is closed. and ideas?

  • Re: Time Delay Pop Up Box


    Quote from zotee98

    is there a way to put a time delay on a pop up box - like show a pop up box for like 2 seconds when the file is opened?


    Code
    Private Sub Workbook_Open()
         CreateObject("WScript.Shell").Popup "Hello", 2
    End Sub
  • Re: Show Popup Box For 2 Seconds On Workbook Open`


    Jindon hope you don't mind:


    Code
    Private Sub Workbook_Open() 
        CreateObject("WScript.Shell").Popup "Hello", 2, "My Pop Up"
    End Sub


    Zotee98, i just added the title "My Pop Up" to Jindon's code just to make it a bit friendlier!

  • Re: Show Popup Box For x Seconds On Workbook Open`


    I was wondering about that. I tried the example: it popped up immediately, and did not got away. (Excel 2003 SP2 on XP)

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

  • Re: Show Popup Box For x Seconds On Workbook Open`


    Quote from shg

    I was wondering about that. I tried the example: it popped up immediately, and did not got away. (Excel 2003 SP2 on XP)


    Yeah I remember I had problems on XP as well - just as in above it wouldnt go away, but it works with vista - weird.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!