Thread: Message Box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Message Box

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