Create Message Box without buttons

[Bijl167]

Hi,

I'm trying to display a message at the end of a macro. But I want the
messagebox without bottons and it should disappear without the user
having to take any action.

I've seen these boxes before in f.i. windows but I can't get them to
work in Excel

Does anyone know how this can be solved in VBA?

thnx

 

[Tom Ogilvy]

See John Walkenbach's site for sample code:

http://j-walk.com/ss/excel/tips/tip39.htm
Creating a "Splash Screen" for a Workbook

 

[Don Guillett]

Here is one I found awhile back. Modify to suit
Sub TimedMessage()
Const Title As String = "Self closing message box"
Const Delay As Byte = 2 'Seconds to Display
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

 

[Bijl167]

Thnx a lot, the delay function works great