Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I copy cell contents to an autoshape as text using a macro?
I want to run a macro in order to copy the contents of a specific cell and
add as text to a specific autoshape already located on a worksheet. For eg contents of cell A249 = 'Andy'. I want the name 'Andy' to transfer to the autoshape as the text on the autoshape. Can anyone provide the code required or know of an easier way? I'm using Excel within Office 2000. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I copy cell contents to an autoshape as text using a macro?
Sub AddText()
Dim shp As Shape Set shp = ActiveSheet.Shapes("Rectangle 1") sText = Range("A249").Text shp.TextFrame.Characters.Text = sText End Sub -- Regards, Tom Ogilvy "Syndrome" wrote: I want to run a macro in order to copy the contents of a specific cell and add as text to a specific autoshape already located on a worksheet. For eg contents of cell A249 = 'Andy'. I want the name 'Andy' to transfer to the autoshape as the text on the autoshape. Can anyone provide the code required or know of an easier way? I'm using Excel within Office 2000. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell contents, then paste into the same cell with other text. | Excel Discussion (Misc queries) | |||
How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) | |||
Macro - copy cell contents IF | Excel Programming | |||
Macro to copy cell contents number of columns | Excel Programming | |||
Copy cell contents into Macro code | Excel Programming |