Using a for loop to call consecutive variable names (ie car1, car2.... car10) in VBA

Question

Scenario) I have seven variables; labelKid1, labelKid2, ...LabelKid3. I'm searching through cells to find ones that are not empty, and then entering the value into the label, starting with labelKid1, and then moving on to the next label.

Question) Is there a way to us a for loop to go through these variables? By this I mean can I somehow call the variable with something such as labelKid + j , with j being the value of the for loop? This would allow me to march through the labels a lot more easily.

Now, I understand that I could probably do this by putting the labels into an array and using a for loop to call their indicies, but is there a way to do it as I stated above?

See http://stackoverflow.com/questions/4777001/vba-is-variable-variable-possible — verdesmarald, Jul 24 '12 at 00:58
Are you talking about variables in VBA (i.e. `Dim x As Integer`) or accessing named ranges on a worksheet through VBA? — Enigmativity, Jul 24 '12 at 01:20

score 3 · Accepted Answer · answered Jul 24 '12 at 01:04

3

No, VBA does not support variable variables (as they are called in PHP). As you said you will need to use a list, dictionary or similar instead.

answered Jul 24 '12 at 01:04

verdesmarald

11,646
2
44
60

Thank you! I didnt realize there was an exact name for what I was looking for. As a budding programmer, much thanks to you! – nobillygreen Jul 24 '12 at 01:39

score 3 · Answer 2 · answered Dec 10 '13 at 15:35

You can achieve this using UserForm1.Controls("labelKid" & i) Which calls any form control by name associated with UserForm1

So you would need something like this

Sub ControlName()
Dim i As Long
For i = 1 To 10
    UserForm1.Controls("labelKid" & i).Value = i 
Next
End Sub

Hope this helps!

Using a for loop to call consecutive variable names (ie car1, car2.... car10) in VBA

2 Answers2

Linked