472,123 Members | 1,326 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,123 software developers and data experts.

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 1966
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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.