469,076 Members | 1,538 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,076 developers. It's quick & easy.

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.screenupdating= false after setting new label caption, so this is not the problem. Can anyone please help me.
Nov 14 '10 #1
1 1891
Guido Geurs
767 Expert 512MB
This is how I change the Command caption in a loop (each time the index is changed).

Expand|Select|Wrap|Line Numbers
  1.    For ARRDATAidx = 1 To UBound(ARRDATA)
  2. ...
  3. ...
  4.    Sheets("DATA").Com_Search.Caption = "Line: " & ARRDATAidx & " from " & UBound(ARRDATA) & " lines checked."
  5. DoEvents
  6.    Next
"DoEvents" let the sheet the time to update the layout.
Nov 15 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Pavan Arise | last post: by
2 posts views Thread by Stone | last post: by
5 posts views Thread by dgardner | last post: by
1 post views Thread by zion | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.