Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add message box after a macro is completed
help please. I have macro that i will like user to know
when the process has been completed. I think i will have to create a form and then creat a message box macro saying "process is completed". I am new to macro so I will please like to the know what i will need. Also, i need this message or prompt to appear infront of any application that might be opened. thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add message box after a macro is completed
wendy wrote:
* i need this message or prompt to appear infront of any application that might be opened. * Hello wendy, In this case, I recommend to use "WScript.Shell" as follows. ;) Code: -------------------- Sub YourProcedule() Dim WScript As Object Set WScript = CreateObject("WScript.Shell") 'Your code here WScript.Popup "Excel Upload Complete", 2, "process is completed", vbSystemModal Set WScript = Nothing End Sub -------------------- --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add message box after a macro is completed
thanks colo. I added it but i am getting an erorr.
This is how my code looks like with your codes: Sub teacher() Dim WScript As Object Set WScript = CreateObject("WScript.Shell") 'the rest of my codes with ends with application.visible=false WScript.Popup "Excel Upload Complete", 2, "process is completed", vbSystemModal Set WScript = Nothing End Sub then -----Original Message----- help please. I have macro that i will like user to know when the process has been completed. I think i will have to create a form and then creat a message box macro saying "process is completed". I am new to macro so I will please like to the know what i will need. Also, i need this message or prompt to appear infront of any application that might be opened. thanks in advance . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add message box after a macro is completed
wendy, please kindly let me have what kind of error did you get?
--- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add message box after a macro is completed
First let me thank you for been so helpfull. everything
works well as it wast, expect at the end it gives me this error: "Run-time error '424'. object required This only happens when i add your code. -----Original Message----- wendy, please kindly let me have what kind of error did you get? --- Message posted from http://www.ExcelForum.com/ . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to add message box after a macro is completed
The code you posted runs fine for me in xl2000, windows 2000
Is the constant vbSystemModal defined? msgbox vbSystemModal does the code you posted work (just that code, not combined with your original)? -- Regards, Tom Ogilvy "wendy" wrote in message ... First let me thank you for been so helpfull. everything works well as it wast, expect at the end it gives me this error: "Run-time error '424'. object required This only happens when i add your code. -----Original Message----- wendy, please kindly let me have what kind of error did you get? --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Message Bar | Excel Discussion (Misc queries) | |||
A macro disabled message comes up but there is no macro. | Excel Discussion (Misc queries) | |||
Macro Pop-Up Message | Excel Discussion (Misc queries) | |||
Message box before another macro | Excel Discussion (Misc queries) | |||
Macro message | Excel Discussion (Misc queries) |