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

[Bob Phillips]

What is the calculation code doing?

[Paul_Hossler]

Try

[vba]
userform1.show vbModeless
[/vba]

and see if that does what you'd like

It's not really a prgress bar, but you can write text to the User form

There are plenty of real Progress Bar modules around that will start with an empty gauge and fill it in with a color are calculations progress

Paul