cannot set controlsource

[dsaffo]

Hi, I am trying to set a controlsource property so that when a cell on a worksheeet is changed, the label will also change. However, when I try to set the controlsource I get an error that says :

Could not set the ControlSource property. Invalid property value.

I've tried it with a label in the code,

lblUser.ControlSource = Worksheets("User List").Range("C1")

and I've tried it in the properties window of a textbox, and I cannot get either to work. I've also unprotected the sheet first, thinking that might have something to do with it. Any help would be appreciated.

 

[Scott Huish]

There is no ControlSource property for a Label.

Is this label on the spreadsheet, if so, is it from the Control Toolbox?
Or is it on a UserForm?

 

[dsaffo]

It is on a userform. I tried it with a textbox as well, but it still will not let me enter it.

 

[Norie]

Like HOTPEPPER said a label doesn't have a controlsource property.

And the controlsource property of a textbox expects a string.

The code you've posted would try to set the property to the value in Worksheets("User List").Range("C1").

Try this.

TextBox1.ControlSource = "'User List'!C1"

 

[dsaffo]

Thanks guys! It works perfectly! This is why I love this site so much

 

[GGladu]

Like HOTPEPPER said a label doesn't have a controlsource property.

And the controlsource property of a textbox expects a string.

The code you've posted would try to set the property to the value in Worksheets("User List").Range("C1").

Try this.

TextBox1.ControlSource = "'User List'!C1"

My code is similar but it doesn't work. My code is like this
Textbox1.controlSource = Worksheet("myworksheet").Range("G" & spinbutton1.Value)
I incorporate a spinbutton to move through the records

If I drop the .controsource it picks up the data fine but I can't update the values