Popping up picture after x amount of time

[ninjao]

Hi again!

I was wondering if it's possible to pop up a picture(or run a macro) after x amount of time?

The result would be a sort of "Information bubble" that I want to pop up to remind the user to do something.

Extra info: I don't know how the "onload" parameter works but the spreadsheet where I would like this bubble popup to appear is not the "First page spreadsheet". It only opens once the user presses a button which links to that spreadsheet.

Thanks in advance
-Ninjao

[alski]

Have you looked at the Wait function?

Type Wait in the VBA Editor and press F1 while the cursor is in the word Wait and see how you get on.

From experience it was quite buggy and made my spreadsheet prone to crashing... it might have been sorted though.

Not sure of how much VBA you know so repost if you need further help!

Hope this helps,

Alex

[blane245]

Here's a routine I found handy that waits for a time to occur and then does something. It uses DoEvents to allow other activity within Excel to occur.

Please Login or Register  to view this content.

Use a loop like this to make it click off regularly

Please Login or Register  to view this content.

[ninjao]

Thanks guys Ill check that out!

I won't mark this has solved yet.