Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi.
Try that. Sub TimedMessage() Const Title As String = "Self closing message box" Const Delay As Byte = 2 ' Tps d'affichage en secondes Const wButtons As Integer = 16 ' Boutons + icone Dim wsh As Object, msg As String Set wsh = CreateObject("WScript.Shell") msg = Space(10) & "Bonjour," & vbLf & vbLf & "Nous sommes le " & Date wsh.Popup msg, Delay, Title, wButtons Set wsh = Nothing End Sub If you want no button set Const wButtons As Integer = 7 + 16 Alain CROS. "Joe 90" a écrit dans le message de news: ... Is vba able to put a timer on a MSgBox, so that OK is "clicked" after a specified time and a macro/code can continue? I have tried allsorts but with Msgbox one seems to get complete freezing of the app and vba. Any help much appreciated. Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
timer | Excel Discussion (Misc queries) | |||
Timer in VBA | Excel Discussion (Misc queries) | |||
Timer | Excel Discussion (Misc queries) | |||
Timer | Excel Worksheet Functions | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) |