I followed the tutorial on wellsr.com to show a progress bar while processing data in an Excel sheet. Using Excel 2016 on Windows 10 Professional.
This is the link to the tutorial: https://wellsr.com/vba/2017/excel/beautiful-vba-progress-bar-with-step-by-step-instructions/
All is fine in the beginning (I have a quite resource intensive algo running through a quite busy Excel sheet) but at a certain moment the progress bar stalls and even the spreadsheet becomes totally black until the regular macro is finished.
I've added the ufProgress.Repaint method after the update of the progress bar values, as suggested in the tutorial. However, no improvement.
Then I've added a delay of 10ms using the Sleep method but that also doesn't bring any improvement.
What could cause this behaviour and how to resolve it?
PS: in the meantime I'm using the Application.Statusbar method to "mimic" the progress bar but it would be much nicer if the progress bar would work as explained/expected in the tutorial.
Any hints welcome!