Use For Next Loop to Append Numbers to Form Property Names

[Decumanus Maximus]

I've created a form with Label names as follows:

lblCard1
lblCard2
lblCard3
etc.

I want to create a For Next loop that'll append the "next" number to the property name of a label for the purposes of changing the caption.

Here's an example (of what doesn't work):

Dim lblCard(i) As String
 
for i = 1 to 12
lblCard(i).Caption = "whatever"
next

I can do it with a regular variable name but not property name. I appreciate any help you can offer.

 

[pgc01]

Hi

Try:

Dim i As Long
 
For i = 1 To 3
    Me.Controls("LblCard" & i).Caption = "Whatever" & i
Next i

 

[Decumanus Maximus]

That did the trick. Thank you very much!