Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript
|
|||
|
|||
![]()
Hi,
I've got a shape that has an asscoiated TextFrame that contains some text. I'd like to replace that text using VBA code. But I can't get it to work. based on the oputput of the macro recorder, this should work: With Sheets("Start").Shapes(7).TextFrame .Characters.Text = "AAAAA" End With But it doesn't. I've also tried to use delete and insert methods of the characters class, but these methods seem to belong to a different charaters class than the one provided by the Shape.TextFrame object. Does anyone know how to do this? Thank you very much, Robert Stober |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Modify cell contents | Excel Discussion (Misc queries) | |||
How do I modify an existing worksheet to remove columns & contents | Excel Discussion (Misc queries) | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions |