| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text in a Rectangle Object
I have a rectangle in a worksheet "Rectangle 43", I want to copy some text I
have in a cell which is a formula (Sheet1!A5&" "&Sheet2!A5) in to this rectangle. I select the cell containing the text, copy this and then select the rectangle but the paste button is not available. I have tried the following but this fails ActiveSheet.Shapes("Rectangle 43").TextFrame.Characters.Text = Sheet1!A5&" "&Sheet2!A5 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text in a Rectangle Object
Hi
Try this: ActiveSheet.Shapes("Rectangle 43").TextFrame.Characters.Text = Worksheets("Sheet1").Range("A5") & " " & Sheets("Sheet2").Range("A5") Regards, Per "Rob" skrev i meddelelsen ... I have a rectangle in a worksheet "Rectangle 43", I want to copy some text I have in a cell which is a formula (Sheet1!A5&" "&Sheet2!A5) in to this rectangle. I select the cell containing the text, copy this and then select the rectangle but the paste button is not available. I have tried the following but this fails ActiveSheet.Shapes("Rectangle 43").TextFrame.Characters.Text = Sheet1!A5&" "&Sheet2!A5 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text in a Rectangle Object
Thanks for this it works a treat
"Per Jessen" wrote: Hi Try this: ActiveSheet.Shapes("Rectangle 43").TextFrame.Characters.Text = Worksheets("Sheet1").Range("A5") & " " & Sheets("Sheet2").Range("A5") Regards, Per "Rob" skrev i meddelelsen ... I have a rectangle in a worksheet "Rectangle 43", I want to copy some text I have in a cell which is a formula (Sheet1!A5&" "&Sheet2!A5) in to this rectangle. I select the cell containing the text, copy this and then select the rectangle but the paste button is not available. I have tried the following but this fails ActiveSheet.Shapes("Rectangle 43").TextFrame.Characters.Text = Sheet1!A5&" "&Sheet2!A5 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Box vs. rectangle, what is the difference? | Excel Discussion (Misc queries) | |||
| text does not update in rectangle box | Excel Programming | |||
| Rectangle object in Worksheet not amenable to word indenting and Undo problems | Excel Discussion (Misc queries) | |||
| Copy Rectangle Object From One Sheet To Another | Excel Discussion (Misc queries) | |||
| Add text to a rectangle in VBA | Excel Programming | |||
Linear Mode
