Thread: set label text of controlformat
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
  
Posts: 2,344
Default set label text of controlformat
Hi,

You might try this or some variation of it

ActiveSheet.Shapes("Label1").Select
Selection.Characters.Text = "abcd"
Range("F10").Select

--
Thanks,
Shane Devenshire


"hoho sklo" wrote:

dim lbl as controlformat.label
set lbl=activesheet.shapes("Label1")
lbl.text="abcd"

this code do not work..
How can I do work?



*** Sent via Developersdex http://www.developersdex.com ***

Reply With QuoteReply With Quote