Excel VBA

Excel VBA
Excel Formulas
User-defined Functions
Office Links
Access VBA
Access SQL
Alan’s Excel FAQ
Excel Home
Alan’s Home

Status Bar

Found this cool piece of code to build a status bar across the bottom of your screen while a long running application is running.
Application.StatusBar = Application.Rept("|", _
  Application.Floor(50 * currRow / lastRow, 1))

The spreadhseet I stole it from had this in a cell that was translating a percentage.

© 2008-2011

Updated:  09/11/2011 15:58
This page added:  02 April 2008