Thank you , Norman.

The URL helps me to understand how to display a progress bar
I have one thing to know. That is how to calculate the percentage.
The URL shows me how to display a progress bar in a single subroutine.
But I want to display that in muliple functions in multiple cells.

eg. Every cell in Range("A1:J100") (=1000cells) has formula " =Test()".
And Function Test() is declared in module1.
When Test() is called from A1 , B2, or C3 and so on,
I want to display how many cells in Range("A1:J100") have been
calculated.

In other words, I want to know how to get how many cells are already
calculated.

Sorry for my poor English.

"Norman Jones" wrote in message
...
Hi Zoo,

See John Walkenbach at:

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

Look also in VBA help for the StatusBar property.

---
Regards,
Norman



"Zoo" wrote in message
...
Excel shows "Calculating cells **%" in the statusbar while calculating.

I want to show my own progress bar instead of that while sheet
calculation.
Does any one know how to do that?