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
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