Problem in displaying a progress bar

[arrun]

Hi all,

Here I am dealing with heavy calculations with VBA, so wanted to put a Userform saying that "calculation is going on". Here my goal is, just when calculations start that userform will pop-up and when it complete that will automatically hides. So I wrote following codes :

[VBA]sub calculation()
userform1.show
.................................
calculations
.................................
userform1.hide
end sub[/VBA]

However this strategy seems not working. calculation() is not doing anything as long as userform1 is open. Once I close it manually then I get the results from calculation(), otherwise it doesn't.

What is the correct way to do that? Am I missing anything ? Your help will be highly appreciated.

Thanks