Labels in Code (xp)

Topic

New Reply

I have some labels named Label1through Label20 on a userform. Is there a way to refer to these labels dynamically from within code using a variable? For example, if the variable is X=2, say, I want to change the BackColor property of Label2 to a different value.

TIA

Reply | Quote

Replies

Yes, you can use

Me.Controls(“Label” & X).BackColor = vbGreen

if the code is in the userform module, or

UserForm1.Controls(“Label” & X).BackColor = vbMagenta

where UserForm1 is the name of the form.

Reply | Quote

Thanks Hans. You are a star!

Reply | Quote