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-2009

Updated:  11/16/2009 23:41
This page added:  02 April 2008