|
show messagen when running a macro?
Hi newsgroup,
when I start one of my complex macros, it takes around half a minute until it ends... is there a possibility to show the user some messages like "I'm currently calculating, please wait a moment..."? - otherwise some people would blindly start clicking something... Thanks for all ideas! Best Markus |
show messagen when running a macro?
You could try this.
http://www.enhanceddatasystems.com/E...rogressBar.htm Robin Hammond www.enhanceddatasystems.com "Markus Scheible" wrote in message ... Hi newsgroup, when I start one of my complex macros, it takes around half a minute until it ends... is there a possibility to show the user some messages like "I'm currently calculating, please wait a moment..."? - otherwise some people would blindly start clicking something... Thanks for all ideas! Best Markus |
show message when running a macro?
Hi Robin,
thanks for the link - unfortunately I get the message "Project is unviewable" if I try to get the VBA code within the VBA editor... Best Markus -----Original Message----- You could try this. http://www.enhanceddatasystems.com/E...ExcelProgressB ar.htm Robin Hammond www.enhanceddatasystems.com "Markus Scheible" wrote in message ... Hi newsgroup, when I start one of my complex macros, it takes around half a minute until it ends... is there a possibility to show the user some messages like "I'm currently calculating, please wait a moment..."? - otherwise some people would blindly start clicking something... Thanks for all ideas! Best Markus . |
show messagen when running a macro?
Markus,
You cannot show a MsgBox as that will halt code. You can however give the user some indications: With Application .StatusBar = "Hang on. Processing..." .Cursor = xlWait 'Process code .StatusBar = "" .Cursor = xlDefault End With NickHK "Markus Scheible" wrote in message ... Hi newsgroup, when I start one of my complex macros, it takes around half a minute until it ends... is there a possibility to show the user some messages like "I'm currently calculating, please wait a moment..."? - otherwise some people would blindly start clicking something... Thanks for all ideas! Best Markus |
show messagen when running a macro?
Hi Nick,
You cannot show a MsgBox as that will halt code. You can I know - thats my problem ;o) I thought about something like a text box which dows not interrupt the macro... the problem is that these Text boxes are not named fixedly but e.g. "Text Box 14" so that I can't automatically delete them after the calculation... however give the user some indications: With Application .StatusBar = "Hang on. Processing..." .Cursor = xlWait Thats quite helpful, thanks; nevertheless more would be better... Best Markus 'Process code .StatusBar = "" .Cursor = xlDefault End With NickHK "Markus Scheible" wrote in message ... Hi newsgroup, when I start one of my complex macros, it takes around half a minute until it ends... is there a possibility to show the user some messages like "I'm currently calculating, please wait a moment..."? - otherwise some people would blindly start clicking something... Thanks for all ideas! Best Markus . |
show message when running a macro?
OK. I am guessing that is because you are using Excel 97 and there's a
digital signature in the file. Check back on my site in 15 minutes. I will have uploaded a 97 version and added a new link to it. Thanks for the feedback. Robin Hammond www.enhanceddatasystems.com "Markus Scheible" wrote in message ... Hi Robin, thanks for the link - unfortunately I get the message "Project is unviewable" if I try to get the VBA code within the VBA editor... Best Markus -----Original Message----- You could try this. http://www.enhanceddatasystems.com/E...ExcelProgressB ar.htm Robin Hammond www.enhanceddatasystems.com "Markus Scheible" wrote in message ... Hi newsgroup, when I start one of my complex macros, it takes around half a minute until it ends... is there a possibility to show the user some messages like "I'm currently calculating, please wait a moment..."? - otherwise some people would blindly start clicking something... Thanks for all ideas! Best Markus . |
show message when running a macro?
Markus,
just updated the page with a 97 version and added a link to the new file. I've tested it on 97 running on NT4 and it seems to be viewable now. HTH, Robin Hammond www.enhanceddatasystems.com "Robin Hammond" wrote in message ... OK. I am guessing that is because you are using Excel 97 and there's a digital signature in the file. Check back on my site in 15 minutes. I will have uploaded a 97 version and added a new link to it. Thanks for the feedback. Robin Hammond www.enhanceddatasystems.com "Markus Scheible" wrote in message ... Hi Robin, thanks for the link - unfortunately I get the message "Project is unviewable" if I try to get the VBA code within the VBA editor... Best Markus -----Original Message----- You could try this. http://www.enhanceddatasystems.com/E...ExcelProgressB ar.htm Robin Hammond www.enhanceddatasystems.com "Markus Scheible" wrote in message .. . Hi newsgroup, when I start one of my complex macros, it takes around half a minute until it ends... is there a possibility to show the user some messages like "I'm currently calculating, please wait a moment..."? - otherwise some people would blindly start clicking something... Thanks for all ideas! Best Markus . |
show message when running a macro?
Hi Robin,
thanks again, now I could open it... unfortunately we all do just have Excel97, so at the moment its "just" the statusbar message... Best Markus -----Original Message----- Markus, just updated the page with a 97 version and added a link to the new file. I've tested it on 97 running on NT4 and it seems to be viewable now. HTH, Robin Hammond www.enhanceddatasystems.com "Robin Hammond" wrote in message ... OK. I am guessing that is because you are using Excel 97 and there's a digital signature in the file. Check back on my site in 15 minutes. I will have uploaded a 97 version and added a new link to it. Thanks for the feedback. Robin Hammond www.enhanceddatasystems.com "Markus Scheible" wrote in message ... Hi Robin, thanks for the link - unfortunately I get the message "Project is unviewable" if I try to get the VBA code within the VBA editor... Best Markus -----Original Message----- You could try this. http://www.enhanceddatasystems.com/ED/Pages/ExcelProgre ssB ar.htm Robin Hammond www.enhanceddatasystems.com "Markus Scheible" wrote in message . .. Hi newsgroup, when I start one of my complex macros, it takes around half a minute until it ends... is there a possibility to show the user some messages like "I'm currently calculating, please wait a moment..."? - otherwise some people would blindly start clicking something... Thanks for all ideas! Best Markus . . |
| All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com