Referencing labels dynamically.
 

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:


---
Message posted from http://www.ExcelForum.com/

Referencing labels dynamically.
 

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

--
Regards,
Tom Ogilvy


"liddlem " wrote in message
...
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:


---
Message posted from http://www.ExcelForum.com/

Referencing labels dynamically.
 

You'll have to use

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



liddlem wrote in message ...
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:


---
Message posted from http://www.ExcelForum.com/