simora
08-13-2016, 08:58 PM
On a worksheet, I have 2 cells which display times; Start time & Current time
I have another cell , J4 which displays the correct Elapsed time. Like 0:02:19
How can I take that cell value and display it correctly in a UserForm Caption.
I Tried various formatting options. None of which worked.
Eg.
Me.Label5.Caption = Format(Time, "hh:mm:ss")
Me.Label5.Caption = Sheets("SheetSales").Range("J5").Value
I have another cell , J4 which displays the correct Elapsed time. Like 0:02:19
How can I take that cell value and display it correctly in a UserForm Caption.
I Tried various formatting options. None of which worked.
Eg.
Me.Label5.Caption = Format(Time, "hh:mm:ss")
Me.Label5.Caption = Sheets("SheetSales").Range("J5").Value