| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| controlformat.enabled failed in excel macro | Excel Programming | |||
| ControlFormat Problem | Excel Programming | |||
| ThisWorkbook.Saved = True does not work when Shapes().ControlFormat.Enabled = False | Excel Programming | |||
| Shape ControlFormat.LinkedCell returns wrong Address for named range - BUG | Excel Programming | |||
| add text to label (label from forms toolbar) | Excel Programming | |||
Hybrid Mode
