Automatically close MsgBox in vbscript?

Question

I am using VBScript to code some automation on excel. I have a MsgBox() within the code, and am looking for a way to close the pop-up window created by MsgBox() automatically without human intervention. Program execution would continue from there.

Did you change your name again Tukai? OMG! Well what you need can be done! ;) It's called a **`MSGBOX timer which gets triggered after being idle....`** — bonCodigo, Dec 31 '12 at 18:57
Here's a very similar question I answered yesterday http://stackoverflow.com/questions/14095982/side-step-application-msgbox-in-vba-excel/14096445#14096445 — Daniel, Dec 31 '12 at 20:24

score 6 · Answer 1 · answered Dec 31 '12 at 20:20

6

The pure VBScript solution is the .PopUp method.

answered Dec 31 '12 at 20:20

Ekkehard.Horner

38,498
2
45
96

+1, definitely ideal. I've used this before from VBA for the same reason. – Daniel Dec 31 '12 at 20:25
@Ekkehard you are gr8 as usual!! – Arup Rakshit Dec 31 '12 at 20:36
@Ekkehard can I have some help here - http://stackoverflow.com/questions/14087681/merger-concatenate-employee-rows-depending-on-their-managers? – Arup Rakshit Dec 31 '12 at 20:40
To make this answer stand alone and be more complete, please edit it to contain a brief example right here too. – Gabriel Staples Jun 21 '17 at 14:38

bonCodigo · Accepted Answer · 2012-12-31T20:12:04.193

4

My comment has provided you tips to search and find out feasible answers. However to save your time, here is some insights.

This post shows how you may manupulate MSGBOX in VB.
Here is the best possible way anyone could think of in terms of VBA.
1. Create a form
2. Use it as a MSGBOX
3. Add a timer
4. Given an elapsed time (idle) close the form.

--

Another method Reference. This uses a Pop-Up box as the MSGBOX.

Code:

Sub Test1()
 Dim AckTime As Integer, InfoBox As Object

 Set InfoBox = CreateObject("WScript.Shell")
 AckTime = 3
 Select Case InfoBox.Popup("Click OK or do nothing within 3 seconds.", _
 AckTime, "This is your Message Box", 0)

 Case 1, -1
  Exit Sub
 End Select
End Sub

edited Dec 31 '12 at 20:12

answered Dec 31 '12 at 19:07

bonCodigo

14,268
1
48
91

any other way to close pop-up window generated by `MsgBox`? – Arup Rakshit Dec 31 '12 at 19:14
1

@Tukai do check on the updated I made on the answer. It seems to be pretty well for you since you are working on VBScript. Try that and comment please. – bonCodigo Dec 31 '12 at 20:13
yes i m trying,but meanwhile could you say what `0` does here ? – Arup Rakshit Dec 31 '12 at 20:21
Here is the [syntax](http://www.itgeared.com/articles/1038-creating-pop-up-message-using-windows/). Please read on. – bonCodigo Dec 31 '12 at 20:32

Automatically close MsgBox in vbscript?

2 Answers2

Linked

Related