How to dynamically update labels captions in VBA form

Question

I want to dynamically set the caption for an array of labels  within a VBA form  based on values stored in a worksheet  Thus far I can set them one-by-one like this   Label1 Caption   MySheet Range  A1   Value Label2 Caption   MySheet Range  B1   Value Label3 Caption   MySheet Range  C1   Value       Having lots of labels that follow a recurrent pattern  I want to use something smarter  like    Method1 For i   1 To X     Dim MyLabel as Object  Set MyLabel    Label   amp  i     MyLabel Caption   MySheet Cells i   1  i  Value Next i  Method2 For i   1 To X     Label i  Caption   MySheet Cells i   1  i  Value Next I  Both Methods failed  I really appreciate some feedback on this

User · Answer

If you want to use this in VBA   For i   1 To X     UserForm1 Controls  Label   amp  i  Caption    MySheet Cells i   1  i  Value Next

User · Answer

Use Controls object  For i   1 To X     Controls  Label   amp  i  Caption    MySheet Cells i   1  i  Value Next

[vba] How to dynamically update labels captions in VBA form?

Examples related to vba

Examples related to excel

Examples related to label