How do I set label caption and make it visible runtime?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • BranX

    How do I set label caption and make it visible runtime?

    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.
  • Guido Geurs
    Recognized Expert Contributor
    • Oct 2009
    • 767

    #2
    This is how I change the Command caption in a loop (each time the index is changed).

    Code:
       For ARRDATAidx = 1 To UBound(ARRDATA)
    ...
    ...
       Sheets("DATA").Com_Search.Caption = "Line: " & ARRDATAidx & " from " & UBound(ARRDATA) & " lines checked."
    DoEvents
       Next
    "DoEvents" let the sheet the time to update the layout.

    Comment

    Working...