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?
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
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
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: 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 shgI 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!