On Screen Loop Counter
 

I would like some code to put in a macro to give me an on screen counte
of the number of times a particular loop has been processed. MsgBo
type functions appear no good as enter needs to be hit each time. An
Ideas ? Thank

--
Message posted from http://www.ExcelForum.com

On Screen Loop Counter
 

The Application.DisplayStatusBar mtehod displays a message at the bas
of the screen.



Try these examples


sub ShowMessage()
Application.DisplayStatusBar = True
Application.DisplayStatusBar = "Hello world"
end Sub

Sub HideMessage
Application.DisplayStatusBar = False
end su

--
Message posted from http://www.ExcelForum.com

On Screen Loop Counter
 

Put it in a worksheet cell

For i = 1 To 10000
ActiveSheet.Range("A1").Value = i
'do your stuff
Next i

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"simoncohen " wrote in message
...
I would like some code to put in a macro to give me an on screen counter
of the number of times a particular loop has been processed. MsgBox
type functions appear no good as enter needs to be hit each time. Any
Ideas ? Thanks


---
Message posted from http://www.ExcelForum.com/

On Screen Loop Counter
 

Thanks Guys - Sorte

--
Message posted from http://www.ExcelForum.com