Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box Duration
When a macro is run and a message box appears (using the 'MsgBox'
command) in visual basic, is there any way to have the message box appear for say 5 seconds and then disspear from the screen, without the user having to click OK. Tony --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box Duration
I use a textbox for things like this. Put on scree, use Wait, the
remove -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box Duration
-----Original Message----- When a macro is run and a message box appears (using the 'MsgBox' command) in visual basic, is there any way to have the message box appear for say 5 seconds and then disspear from the screen, without the user having to click OK. That would require suspension of activity. What you could do instead is to create a new empty sheet and write a message into a Cell. Then either Wait, or continue processing. Then, after the Wait time, or after the processing is complete, delete that worksheet. RClay AT haswell DOT com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box Duration
Newbie wrote:
*Have you tried the OnTime method? "TONYC " wrote: When a macro is run and a message box appears (using the 'MsgBox' command) in visual basic, is there any way to have the messag box appear for say 5 seconds and then disspear from the screen, withou the user having to click OK. Tony --- Message posted from http://www.ExcelForum.com/ * No I have not tried the OnTime method, can you please elaborate Ton -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message Box Duration
Hi,
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Sub TEST() With CreateObject("WScript.Shell") ' Message ,Time, Title ,Type .Popup "Welcome...", 5, "Excel User Group Korea", 0 End With End Sub - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Regards, Soo Cheon Jheong _ _ ^ąŻ^ -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format duration in mm/dd hh:mm | Excel Worksheet Functions | |||
duration | Excel Worksheet Functions | |||
fx duration | Excel Worksheet Functions | |||
Duration | Excel Discussion (Misc queries) | |||
Duration | Excel Discussion (Misc queries) |