On Screen Loop Counter

[simoncohen]

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

 

[Kieran]

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

 

[Bob Phillips]

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]

Thanks Guys - Sorte