Labels On Userforms (2000)

Topic

New Reply

I have a userform on which are placed several labels. The labels are named:
lbl1, lbl2, lbl3 etc. I want to generate a random number and use that number to select the label and change its background colour.
Eg, random number 6 then lbl6 is referenced.
I’ve done this before, I’m sure, but the syntax for referencing the label with a variable eludes me.
Any takers?

TIA

Reply | Quote

Replies

Let’s say that you have a variable intLabelNo. You can use code similar to this:

intLabelNo = Int(10 * Rnd + 1)
Me.Controls(“lbl” & intLabelNo).BackColor = vbRed

Reply | Quote

Many thanks, Hans.

Reply | Quote