I have a label on a worksheet. When I press a button on the same worksheet, the program should set the new label caption and do some other calculations. The problem is, that new label caption is visible after the program finishes. I have put application.scr eenupdating= false after setting new label caption, so this is not the problem. Can anyone please help me.
How do I set label caption and make it visible runtime?
Collapse
X
-
This is how I change the Command caption in a loop (each time the index is changed).
"DoEvents" let the sheet the time to update the layout.Code:For ARRDATAidx = 1 To UBound(ARRDATA) ... ... Sheets("DATA").Com_Search.Caption = "Line: " & ARRDATAidx & " from " & UBound(ARRDATA) & " lines checked." DoEvents Next
Comment