Message Box

[PBANKS]

Is it possible to answer "Yes" or "No" to a message box through VBA without actually doing it manually?

[Dave Peterson]

If you know what the answer is, why bother asking?

This seems to work under some versions of windows:

CreateObject("WScript.Shell").Popup "Hello", 4, _
"This closes itself in 4 seconds"

But it doesn't work in all versions of windows.

Maybe designing a userform would be best.



PBANKS wrote:
>
> Is it possible to answer "Yes" or "No" to a message box through VBA
> without actually doing it manually?
>
> --
> PBANKS
> ------------------------------------------------------------------------
> PBANKS's Profile: http://www.excelforum.com/member.php...o&userid=31370
> View this thread: http://www.excelforum.com/showthread...hreadid=515928

--

Dave Peterson

[Dave Peterson]

And then use application.ontime to dismiss it.

Chip Pearson has lots of instructions at:
http://www.cpearson.com/excel/ontime.htm

PBANKS wrote:
>
> Is it possible to answer "Yes" or "No" to a message box through VBA
> without actually doing it manually?
>
> --
> PBANKS
> ------------------------------------------------------------------------
> PBANKS's Profile: http://www.excelforum.com/member.php...o&userid=31370
> View this thread: http://www.excelforum.com/showthread...hreadid=515928

--

Dave Peterson

[PBANKS]

Outlook security is the reason, found "click yes" on the web. Works great!