How to display progress on Excel Status bar?

How can we add some text to the status bar in Excel, for example, display x % completed in the lower left hand corner in Excel doc (I think Application.DoEvents() is requred when changing the text) Please advice.

Thanks.


Answer this question

How to display progress on Excel Status bar?

  • Freudi

    Just resetting the message to nothing :

    Microsoft.Office.Interop.Excel.Application excelApp;
    excelApp.StatusBar = "";



  • marijabo

    ok - that works well (thanks!).

    Now, does anyone know how to do the same thing with Outlook 2003

    Thanks!


  • Maxicus

    I've done that simply using :

    Microsoft.Office.Interop.Excel.Application excelApp;
    excelApp.StatusBar =
    String.Format("Processing line {0} on {1}.",rows,rowNum);

    HTH

    Emmanuel



  • dx_user

    Very nice Emmanuel!

    BTW, How can I reset the status bar message

  • How to display progress on Excel Status bar?