Reference Label on Worksheet

pootle flump · #1 (**permalink**) 10-21-09, 09:31

Hi

I have a label from the Controls Toolbox on a worksheet. I would like to set a programmatic reference to it. How would I do so please?

e.g.

Code:

Dim l As MSForms.Label

Set l = ActiveSheet.Shapes("LabelName")

This fails of course - how can I get an early bound reference please?

Thanks

Colin Legg · #2 (**permalink**) 10-21-09, 11:24

For ActiveX objects, something like this should do the trick:

Code:

Sub foo()
    Dim lbl As MSForms.Label
    
    Set lbl = Sheet1.OLEObjects("Label1").Object
    
    'etc...
    
End Sub

Hope that helps...

pootle flump · #3 (**permalink**) 10-21-09, 12:03

Nnnng! So close (one attempt was just like that but I missed the .Object bit).

Thank you very much