Use For Next Loop to Append Numbers to Form Property Names

Decumanus Maximus

New Member
Joined
Sep 22, 2008
Messages
13
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):

Code:
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.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
Hi

Try:

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

Watch MrExcel Video

Forum statistics

Threads
1,129,385
Messages
5,636,001
Members
416,891
Latest member
Okomomo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top