Hello, I have spent a lot of time trying to figure out how to check for
a particular condition on the status bar. I would like to be able to
verify - obviously by a means other than actually looking at the status
bar - whether the status bar displays "calculate". If you know how to
do this please let me know. Thanks.

Try checking

application.StatusBar

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello, I have spent a lot of time trying to figure out how to check for
> a particular condition on the status bar. I would like to be able to
> verify - obviously by a means other than actually looking at the status
> bar - whether the status bar displays "calculate". If you know how to
> do this please let me know. Thanks.
>

Do you mean the "Calculating..." that Excel can show there whilst it is
updating the cells ?
If so, I don't believe you can tell directly, because Excel has control on
the Status bar at that moment.
You can test that with:
If Application.StatusBar = False Then
although I'm not sure if this would run until the calculation has finished.

If you are controlling the Statusbar, then you can test its value
If Application.StatusBar ="calculate" Then

NickHK
P.S. You could try the Windows API on the StatusBar, as it is class EXCEL4
and exposes a handle.


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello, I have spent a lot of time trying to figure out how to check for
> a particular condition on the status bar. I would like to be able to
> verify - obviously by a means other than actually looking at the status
> bar - whether the status bar displays "calculate". If you know how to
> do this please let me know. Thanks.
>