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???


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

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

--
Regards,
Tom Ogilvy

"Crowbar via OfficeKB.com" <u15117@uwe wrote in message
news:56519a148d2d5@uwe...
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???


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1