How do I access the contents of a Text box (that is a drawing object shape on
a worksheet).

For example I wish to manipulate the text a user has typed into the box, and
edit/change the contents of the box.

I cannot find a property such a Text or Value, that I use for UserForm
controls.

Thanks

Hi,

This will replace current contents with "My Text".
You will need to adjust how you reference the control. The examples use name
and index.

Activesheet.shapes(1).textframe.characters.text="M y Text"
or
Activesheet.shapes("Text Box 1").textframe.characters.text="My Text"

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Nigel RS" wrote in message
...
How do I access the contents of a Text box (that is a drawing object shape
on
a worksheet).

For example I wish to manipulate the text a user has typed into the box,
and
edit/change the contents of the box.

I cannot find a property such a Text or Value, that I use for UserForm
controls.

Thanks

Hi Andy
Thanks. It is the TextFrame property I was not aware of.

Cheers


"Andy Pope" wrote:

Hi,

This will replace current contents with "My Text".
You will need to adjust how you reference the control. The examples use name
and index.

Activesheet.shapes(1).textframe.characters.text="M y Text"
or
Activesheet.shapes("Text Box 1").textframe.characters.text="My Text"

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Nigel RS" wrote in message
...
How do I access the contents of a Text box (that is a drawing object shape
on
a worksheet).

For example I wish to manipulate the text a user has typed into the box,
and
edit/change the contents of the box.

I cannot find a property such a Text or Value, that I use for UserForm
controls.

Thanks