Hello all,
How can I use the status bar at the bottom to be used as a progress bar for notifying the end-user to wait until vba completes running in the background. So far I have experimented a little with unicode character ChrW(9616) and liked the results. With my novice vba know how I can't make it to progress though. Thus will appreciate a lot any feedback on this. The following is the code I use
After running the code I get the same as the image...
So how do I change the code to make this into an animated progress bar. I believe the status bar has room for 100 character and the current characters count is somewhere around 30. What if I want to progress it by 5 characters every N seconds til I reach 100th character and the end of my code at the same time?? I will have to make an estimate. So if my code takes 40 seconds to run the N will need to be 2.5 seconds .
Anyone please want to give it a try?
How can I use the status bar at the bottom to be used as a progress bar for notifying the end-user to wait until vba completes running in the background. So far I have experimented a little with unicode character ChrW(9616) and liked the results. With my novice vba know how I can't make it to progress though. Thus will appreciate a lot any feedback on this. The following is the code I use
VBA Code:
Sub progbar()
Dim Lst
I = ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616) & ChrW(9616)
Application.StatusBar = Lst
End Sub
After running the code I get the same as the image...
So how do I change the code to make this into an animated progress bar. I believe the status bar has room for 100 character and the current characters count is somewhere around 30. What if I want to progress it by 5 characters every N seconds til I reach 100th character and the end of my code at the same time?? I will have to make an estimate. So if my code takes 40 seconds to run the N will need to be 2.5 seconds .
Anyone please want to give it a try?