Thread: Reference Label on Worksheet
View Single Post
  #1 (permalink)  
Old 10-21-09, 09:31
pootle flump pootle flump is offline
King of Understatement
  
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
Reference Label on Worksheet
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
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote