How to show a progress bar in sheet calculation?

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" <ayamashi@infoseek.jp> wrote in message
news:uwm2bRB5FHA.3880@TK2MSFTNGP12.phx.gbl...
> 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" <normanjones@whereforartthou.com> wrote in message
news:ODBdeaB5FHA.3036@TK2MSFTNGP15.phx.gbl...
> 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" <ayamashi@infoseek.jp> wrote in message
> news:uwm2bRB5FHA.3880@TK2MSFTNGP12.phx.gbl...
> > 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" <ayamashi@infoseek.jp> wrote in message
news:eU3V7zB5FHA.2636@TK2MSFTNGP10.phx.gbl...
> 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" <normanjones@whereforartthou.com> wrote in message
> news:ODBdeaB5FHA.3036@TK2MSFTNGP15.phx.gbl...
>> 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" <ayamashi@infoseek.jp> wrote in message
>> news:uwm2bRB5FHA.3880@TK2MSFTNGP12.phx.gbl...
>> > 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" <normanjones@whereforartthou.com> wrote in message
news:O5edKHC5FHA.3188@TK2MSFTNGP15.phx.gbl...
> 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" <ayamashi@infoseek.jp> wrote in message
> news:eU3V7zB5FHA.2636@TK2MSFTNGP10.phx.gbl...
> > 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" <normanjones@whereforartthou.com> wrote in message
> > news:ODBdeaB5FHA.3036@TK2MSFTNGP15.phx.gbl...
> >> 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" <ayamashi@infoseek.jp> wrote in message
> >> news:uwm2bRB5FHA.3880@TK2MSFTNGP12.phx.gbl...
> >> > 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?
> >>
> >>
> >
>
>