PDA

View Full Version : [SOLVED] Show in Label value in cell specific column (everey minute)



marreco
07-11-2014, 05:54 AM
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-programming-vba-macros/1023451-show-in-label-value-in-cell-specific-column-everey-minute.html

Thank you

p45cal
07-11-2014, 07:05 AM
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
07-11-2014, 07:39 AM
Hi
i try using inside Userform, show next error

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

marreco
07-11-2014, 09:14 AM
Hi look my file

p45cal
07-11-2014, 10:08 AM
see attached.

marreco
07-11-2014, 10:18 AM
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.