Referencing labels dynamically.

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

Tom Ogilvy

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
 
J

John Tjia

You'll have to use

Controls("Label" & MyCount) = Sheets("Questions").Range(MyRange)
 
Top