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?

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?

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?

Hi Zoo,

I want to display how many cells in Range("A1:J100") have
been calculated.

Although Excel can display recalculation statistics in the status bar, I am
not aware that this information is accessible from VBA.

---
Regards,
Norman



"Zoo" wrote in message
...
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?

Hi, Norman.

It seems that I have to give up.
Thank you so much.

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

I want to display how many cells in Range("A1:J100") have
been calculated.

Although Excel can display recalculation statistics in the status bar, I
am
not aware that this information is accessible from VBA.

---
Regards,
Norman



"Zoo" wrote in message
...
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?