| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Error setting shape text property
Hi guys and girls(i'm told there are a few of you out there),
I have seen posted on MSDN that the Text property can not be set on a shape via VBA using excel 2002. http://support.microsoft.com/default...7293#appliesto The work around sounds hillarious, using Word to create a shape object for us and then doing a copy / paste via automation. I have the same issue with excel 2003 is there any other way to provide a text area on a chart that is movable and can change the text property? For reference the line of code that errors is ActiveSheet.Shapes(1).TextFrame.Characters.Text = "Hello" Runtime Error '1004' - Unable to set the Text property of the Characters class Regards Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dates and text | Excel Discussion (Misc queries) | |||
| Cell text based on 4 condition test | Excel Worksheet Functions | |||
| Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
| Capturing Shape Name/Text from OnAction property | Excel Discussion (Misc queries) | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
Threaded Mode
