ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Buttonless MsgBox? (https://www.excelbanter.com/excel-programming/296470-buttonless-msgbox.html)

Kiloran[_3_]

Buttonless MsgBox?
 
I want to create something like a MsgBox (system modal, ideally), but which
only displays for a few seconds.

It seems to me that the standard MsgBox always has buttons (OK, Cancel,
etc), which require user action to permit the macro to continue

Any way to do what I need?

--Kiloran



Michel Pierron

Buttonless MsgBox?
 
Hi Kiloran;
May be:
Sub Test()
With CreateObject("Wscript.Shell")
.Popup "This message will be displayed for 3 seconds" _
, 3, "Self Closing MsgBox", 64
End With
End Sub

MP

"Kiloran" a écrit dans le message de
...
I want to create something like a MsgBox (system modal, ideally), but

which
only displays for a few seconds.

It seems to me that the standard MsgBox always has buttons (OK, Cancel,
etc), which require user action to permit the macro to continue

Any way to do what I need?

--Kiloran






All times are GMT +1. The time now is 03:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com