Referencing labels dynamically.

  • Thread starter Thread starter liddlem
  • Start date Start date
L

liddlem

Hi folks
I have a database with 12 sets of 10 questions.
I therefore have 10 labels on my userform. (One for each question in
the set)

When the user clicks on the NEXT button, I want to change the value of
label to the new question set.

I have tried the following.

For MyCount = 1 To 10
MyRange = "B" & MyCount
Label(MyCount) = Sheets("Questions").Range(MyRange)
Next MyCount

The problem is that "Label(MyCount)" does not work.

Does anybody know how reference the labels dynamically.
Thanks :confused:
 
if the labels have names like label1, label2 then

For MyCount = 1 To 10
MyRange = "B" & MyCount
Userform1.Controls("Label" &MyCount).Caption =
Sheets("Questions").Range(MyRange)
Next MyCount
 
Back
Top