Populate a label caption from a cell reference

[colinitaylor]

Im really new to VBA and was wondering if it is possible for a label caption to be linked to a referenced cell?

All advice appreciated

 

[daniels012]

Not sure if this is what you are after but,
If you have a text box (label) select it, then go to the formula bar enter a formula referencing the cell.
ie: =A7

Then anything you type.... goes into the text box.

Hope this helps,
Michael

 

[colinitaylor]

Thanks Michael, not too sure what you mean. I am creating a userform and think I should either be writing some code or modifying a property?

 

[daniels012]

Right click on the label in your user form.
You will see properties, click it.
In the long list of properties, find ControlSource.

Then enter in the box to the right =A7 or
whatever your cell reference is

Michael

 

[Norie]

There is no property to modify to use a range for the caption of a label.

You need code, perhaps something like this.

Label1.Caption = Range("A7")

 

[daniels012]

I did it with ControlSource??
Michael

 

[daniels012]

My bad I was doing it for a text box!!
NOrie why would I even attempt to challenge you...

Michael

 

[Norie]

Michael

I can't find a ControlSource property for a Label control either on a userform or from the ControlToolbox.

Mind you my system is pretty ancient.

 

[colinitaylor]

Thanks Norie I was thinking along those lines. Still cant get it to work. Am I doing something foolish?

Sub GetMatchFixtures()

Label1 = Range("Match1")

End Sub

With Match1 being a named cell?

 

[Norie]

What problem are you having?

Where/when are you running that code?