check status bar condition

[ccafferata]

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.

 

[Bob Phillips]

Try checking

application.StatusBar

--
HTH

Bob Phillips

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

 

[NickHK]

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.