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
|