How can I build a GUI that shows the progression of a work ?
-
Hello world, I have written a code for excel, that do some work automatically. My Problem is, that during this time (About 5 Minutes) nothing occures on the screen. Now I want to build a little GUI, that shows the user the progression of the work (something like the one that shows the work of ScanDisk or Defrag). Can someone please tell me which API-Functions, Animated GIF's etc. do I need ? Thanks a lot Tom
-
Hello world, I have written a code for excel, that do some work automatically. My Problem is, that during this time (About 5 Minutes) nothing occures on the screen. Now I want to build a little GUI, that shows the user the progression of the work (something like the one that shows the work of ScanDisk or Defrag). Can someone please tell me which API-Functions, Animated GIF's etc. do I need ? Thanks a lot Tom
Since you mention Excel I’m guessing you’re using VBA. Look to see if VBA supports DoEvents. If it does then put that in your loop w/ some sort of form is not modal which you update from w/in the loop.