Show in Label value in cell specific column (everey minute)

[marreco]

Hi

is possible......
I want is that the F column in the spreadsheet line by line every minute in the label is shown. Ie a macro which cuts jumping from column F and row by row showing the label to get the blank line making a loop.

example: Label1.Caption = range ("F2") - shown for 1 minute then
Label1.Caption = Range ("F3") - shown for 1 minute then
and so on ...

Cross-Post
http://www.excelforum.com/excel-prog...ey-minute.html

Thank you

[p45cal]

Sub dddd()
Static lcap As Range
If lcap Is Nothing Then
  Set lcap = Range("F2")
Else
  Set lcap = lcap.Offset(1)
  If lcap.Value = "" Then Set lcap = Range("F2")
End If
Sheets("Sheet1").Label1.Caption = lcap.Value
Application.OnTime Now + TimeValue("00:01:00"), "dddd"
End Sub

[marreco]

Hi
i try using inside Userform, show next error

time error '438 '
The object does not support this property or method

[marreco]

Hi look my file

[p45cal]

see attached.

[marreco]

Hi, very very good!

i'm very glad your help.

Sorry, but i can't click in star show this

You must spread some Reputation around before giving it to p45cal again.