Auto close msg box

[dode]

Hi

I am looking for a vba code to to close a message box after a few seconds. I can get it to work on one spreadsheet but not another. What would cause this?

Thanks

George

[Marc L]

Hi,

the code for sure …

[Fotis1991]

Hello

Something like this?

Please Login or Register  to view this content.

[dode]

Hello

Something like this?

Please Login or Register  to view this content.

Thanks, but that does not work for me. It stays open

[HaHoBe]

Hi, dode,

the code Fotis supplied is working fine for me (I used 3 seconds) - maybe consider to use a UserForm which could be released after the wanted time (timer would be started when UF is activated/initialized).

This is a more detailed sample of the code supplied:

Please Login or Register  to view this content.

Ciao,
Holger

[dode]

Hi, dode,

the code Fotis supplied is working fine for me (I used 3 seconds) - maybe consider to use a UserForm which could be released after the wanted time (timer would be started when UF is activated/initialized).

This is a more detailed sample of the code supplied:

Please Login or Register  to view this content.

Ciao,
Holger

Thanks. Is there a setting somewhere I have to adjust to make it work. Both codes do work, but not on all of my workbooks. I'm a bit confused what the difference is

Thanks

George

[Fotis1991]

A small example of what i suggested..

[dode]

Would it make a difference running on xp?

[Fotis1991]

No. ................

[dode]

I eventually got it to work. I'm not entirely sure why it wasnt working on all workbooks but when I opened another workbook and went back to the first one, it worked.

Thanks for your help

George

[romperstomper]

The Popup method is not reliable in my experience so I'd be careful about relying on it. I'd always use a userform in preference, myself, as HaHoBe suggested.

[john55]

I think a small Userform is better as Hahobe and Rory already said.
something like that....

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.