I have a simple macro that I use to calculate selections:

Please Login or Register  to view this content.
The problem is I have no clue how long this will take. I want to see a percentage like when using F9 or SHIFT+F9 to calculate. I've looked at some guides online about creating progress bars, but all of them are used in loops. Within a loop it is easy to update the progress of the bar, but I have no idea how to do that with my code. Any ideas?