Tyw214 Posted July 15, 2016 Posted July 15, 2016 Basically, i have a script that sums a bunch of number using different functions, and it sometimes can take up to 15-20 seconds to finish. At the end, a msgbox pops up to tell the user the total, but is there some kind of thing that I can add during that 15-20 seconds while its running to tell the user that it's "working" and not like just doing nothing/frozen? Thanks!
Moderators JLogan3o13 Posted July 15, 2016 Moderators Posted July 15, 2016 (edited) Yes, look at ProgressSet in the help file. The example script contained therein will give you some ideas. Edited July 15, 2016 by JLogan3o13 "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum!
AutoBert Posted July 15, 2016 Posted July 15, 2016 ToolTip is a possibility. If you have a Gui, you can insert a label, which data is updated. Also possible with GUI using a GUICtrlCreateProgess, using Marquee-Style if no calculantion of done % is possible.
SadBunny Posted July 15, 2016 Posted July 15, 2016 All kinds of things. I personally like to go with audio feedback (like a short beep every second with increasing frequency), but there's always things like ProgressOn/ProgressSet/ProgressOff (and many variants are available). To avoid having to interrupt your calculation process with a test to see whether a progress meter should be increased however you could simply use an AdlibRegister() to execute a function every X msec's that beeps or consolewrites or traytips or updates a gui or whatever you want, and unregister that after the calculation is done. Roses are FF0000, violets are 0000FF... All my base are belong to you.
water Posted July 15, 2016 Posted July 15, 2016 SplashTextOn is another function to do what you want to do. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now