Show Popup Box For x Seconds On Workbook Open`

Re: Time Delay Pop Up Box

You could have a user form with a message show up for a time period.

Have a look at ontime.

Re: Time Delay Pop Up Box

Actually the wait method could also work.

Re: Time Delay Pop Up Box

Hmm I would have to think more seriously about the wait method. But heres an example using my first suggestion of using ontime.

HTH

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?

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:

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`

Just be aware that wsh timer does not work in some situations.
What these are I am not sure of, BUT I have had it NOT work using Xl2003 OS: XP

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)

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.