check status bar condition
 

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.

check status bar condition
 

Try checking

application.StatusBar

--
HTH

Bob Phillips

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

wrote in message
oups.com...
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.

check status bar condition
 

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.


wrote in message
oups.com...
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.