View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
CarlosAntenna CarlosAntenna is offline
external usenet poster
 
Posts: 22
Default MsgBox with Timer

Thanks Big. I have not tried your solution because I already got it working
with Chip's method. Yours looks like exactly the kind of work-around I was
looking for.

Thanks,
--Carlos

"bigwheel" wrote in message
...
You could make your msgbox with a user form and have the form run the
following when it activates

Private Sub UserForm_Activate()

Application.OnTime Now + TimeValue("00:00:10"), "CloseForm"

End Sub

The "CloseForm" is a macro which closes the user form :-

Public Sub CloseForm()
Unload userform1
End Sub


"CarlosAntenna" wrote:

Is it possible to display a MsgBox for 5 seconds and then make it

disappear
without clicking the OK button? I looked at help under MsgBox but did

not
see such an option. Is there some other way to achieve the same result?

--Carlos