It is not clear where the long running code resides. If it resides in User Form, maybe you can simply add a colored label to this form and increase the length of it when the code did some progress. Another more complicated way is to create second User Form which will contain the Progress Label and this second User Form will have Event which will call back to first User Form where the long running operation runs after this Progress Form was activated (more info [here](https://www.amazon.com/Advanced-Microsoft-Visual-Basic-6-0/dp/B00006L568)).