Posted to microsoft.public.excel.programming

hoho sklo

external usenet poster

Posts: 6

set label text of controlformat

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
controlformat.enabled failed in excel macro	DAACKM	Excel Programming	1	September 15th 08 05:32 PM
ControlFormat Problem	equiangular	Excel Programming	2	February 28th 07 06:20 AM
ThisWorkbook.Saved = True does not work when Shapes().ControlFormat.Enabled = False	Joe HM	Excel Programming	0	August 3rd 06 07:46 PM
Shape ControlFormat.LinkedCell returns wrong Address for named range - BUG	[email protected]	Excel Programming	10	July 14th 06 03:05 PM
add text to label (label from forms toolbar)	Rob Bovey	Excel Programming	0	September 5th 03 09:46 PM

All times are GMT +1. The time now is 12:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us