Hi Forum Members I have developed an Excel 2003 vba programme to calculate the values of commissions payable to a number of different organisations.Following a series of calculations initiated via a userform, a bespoke statement is then generated in Word the whole process taking approximately 7 seconds. Next, you can drag a frame control on the Userform. You can do this by clicking on Frame from the Toolbox.Once this has been completed, the result should be consistent with the picture of the Userform shown earlier. Place a command button on your worksheet and add the following code line to show the Userform: If you have gone through the other Userform examples on this site, you know that this is the time to create the Sub User Form_Initialize. If you are in a hurry, just execute the following steps and you will be fine. Place the sub named code into a module (In the Visual Basic Editor, click Insert, Module). This is THE place to add your own code when you want to use this progress indicator for your own macro. The variable pct Compl (abbreviation for percentage Completed) measures the progress of the macro. The second code line changes the width of the second label control. The Status Bar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro.
If the Set wd App = Get Object line returns returns an existing Word instance then the problem goes away. Asynch is where one process kicks off another, then let's it run to completion without monitoring progress.
Some of the most asked questions that can be (or have been) solved by using ASAP Utilities.
In the "Info..." option in ASAP Utilities you can find the same brief description of each tool.
Status Bar = "Updating " & cl.value For each cl Update in rng Update wb Master.
Note that at the start of the code I have the following Application.