Thread: Flash a MsgBox
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Flash a MsgBox

As I recall, you can't execute a command with Ontime. You can executed a
macro that has the command.

--
Regards,
Tom Ogilvy

"Jim Thomlinson" wrote in message
...
Nope msgboxes require user input. You could however load a form that is on

a
timer... In the on open for the form use something like this

application.ontime now + timevalue("00:00:10"), "unload me"

That code is untested but I think it will work.

HTH

"Stever" wrote:

I'd like to flash a Msgbox on the screen after a process has finished.
However, I don't want the user to have to press enter (i.e. vbOKCancel).

Is
there a way to flash a message and won't require the user to click thru

it??
Thanks.