Excel VBA

Excel VBA
Excel Formulas
User-defined Functions
Excel 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.

© MMVIII

Updated:  04/02/2008 19:33
This page added:  02 April 2008