XL Macro: Timed Message Box?

[ggelineau]

I have built a large macro to format an xl workbook and I was considering adding a message box at the end of the macro that tells the user the macro has ended just before the macro workbook closes itself. Is it possible to use a msg box (or some other box...not sure what exists) that states the Macro has ended and then disappears after a certain amount of time (like five seconds)?

If not, perhaps a message box that only allows the user to hit an "OK" button and then promptly makes the msg box disapear and the macro workbook close.

Also, is it possible to have a macro close the workbook that contains the actual macro (after the macro has completed its run)?

Any insight would be most appreciated.

Thanks,
G

 

[lenze]

Just place the MsgBox at the end of your code.

 MsgBox "Macro has completed"

lenze

Wouldn't simply using a Formatted template be easier?

 

[Smitty]

Do a board search for "Progress Bar", as there've been a bunch of discussions on how to notify users that code is running.

To close the wb you can use: ThisWorkbook.Close True (to save it, False not to)

HTH,

(Heya Lenze!)

 

[ggelineau]

In Case anyone is interested, I found the following code used to create a timed pop-up box:

Sub SelfClosingMsgBox()
CreateObject("WScript.Shell").Popup "Hello", _
2, "This closes itself in 2 seconds"
End Sub


I found the code on the following website:

http://www.mvps.org/dmcritchie/excel/inputbox.htm

-G-