Userform to ignore current calculation

[Crowbar via OfficeKB.com]

I have a file that triggers a series of calculations on opening(removes
columns, rows,inserts borders etc). At the end of these processes it prompts
up a userform to say its complete.

What I want is a userform to sit inveiw while calculating saying calculating..
.... please wait or even a simple progress bar while the calculation is in
progress.

When I ask VB to throw up a userform saying calculating, on doing so it
freezes calculation unless a put a button on it to continue (which is not
really what I want)

Any Ideas???

 

[Tom Ogilvy]

Your almost there. You need to run the code from the userform.



See this technique in John Walkenbach's progress bar sample:

http://www.j-walk.com/ss/excel/tips/tip34.htm