Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Timer in VBA | Excel Discussion (Misc queries) | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
timer | Excel Programming | |||
Timer | Excel Programming | |||
Put a timer on a MsgBox? | Excel Programming |