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