Pop Up Box

[Neo-fite]

Is it possible to display a Pop Up box for the user, but not have the code wait for a response?

 

[clive2002]

You can have a form on a timer, if you just want to splash a message up which then closes

 

[HaHoBe]

Hi, Neo-fite,

using an userform and a on-time event is the way that should always work. A different approach which may not run constantly on all computers where it should be used is using WScript:

Sub MsgBoxGoes()
'add refewrence to Microsoft Scripoting Runtime in VBE
Dim objWSH As Object
Dim var
Const cbytTIME As Byte = 2 'change duration of showing the box here

Set objWSH = CreateObject("WScript.Shell")
var = objWSH.Popup("MsgBox to go ;-)", cbytTIME, "on the fly")
Set objWSH = Nothing
End Sub

Worked on my notebook (7 64 bit, Excel2007) but not on my desktop (XP Pro, Excel2000 which has both problems with WSH and WMI due to Net Framework as VBNet had never been properly been installed there).

Ciao,
Holger

 

[godsspeed]

...what are you trying to accomplish with this Pop-up Box?