Using VBA: Assign value to label control on userform

Question

I am working in the VBA code behind a userform. I have a string variable named block that corresponds to the name of a text label on my userform. After looking at other questions it seems using the controls function gives the ability to control the settings of a label on the userform. The block variable is a string of the labels name.I get an error at all attempts below

 Me.Controls(block).BackColor = &HFFFF&

When I try to hard code it to make sure it is the exact name of the label I still get an error

 Me.Controls("S111").BackColor = &HFFFF&

The following line DOES work:

 Me.S111.BackColor = &HFFFF&

When I try a similar technique I get another error with:

Me.block.BackColor = &HFFFF&

What am I doing wrong and is what I am doing possible?

I assume that block variable stores value "S111". Am i right? — Maciej Los
– Maciej Los, Commented Jun 19, 2015 at 20:52
Is the code actually in the userform's code module? Otherwise the Me keyword will not be referring to the user form and will therefore cause an error. — SierraOscar
– SierraOscar, Commented Jun 19, 2015 at 22:01

SuperBiasedMan · Accepted Answer · 2015-06-20 16:09:07Z

1

The control Me.S111 is an object.

Dim objObject as Object '(Not type String)
Set objObject = Me.S111
objObject.BackColor = &HFFFF&

edited Jun 20, 2015 at 16:09

SuperBiasedMan

10k11 gold badges52 silver badges76 bronze badges

answered Jun 20, 2015 at 15:30

Doug Detweiler

261 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using VBA: Assign value to label control on userform

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related