| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a TextBox (shape)
OssieMac -
Thank you, Mark "OssieMac" wrote: Hi Mark, I haven't been able to do this without actually activating the 2nd workbook and worksheet and selecting the paste location. However, here is what I have that works but maybe someone else can do it better. Windows("Book1").Activate Sheets("Sheet1").Shapes("TextBox1").Copy Windows("Book4").Activate Sheets("Sheet2").Activate Range("B8").Select ActiveSheet.Paste -- Regards, OssieMac "Mark" wrote: Hi - I am working in C# VSTO and Excel 2007 but thought I'd ask how to do this in VBA and maybe it would help with the C# code. I just want to copy a shape (textbox) with all of its text and formating (e.g., Bold, no fill, no line). And paste it multiple times down the page (via a loop), actually to a different workbook. I've tried shape.copy but don't know how to paste it where I want it. I've tried shape.duplicate but can't get that to work either. Much thanks for ideas. Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a TextBox (shape) | Excel Programming | |||
| Place formatted Text in Shape(textbox) | Excel Programming | |||
| set color of textbox (shape) bullets | Excel Programming | |||
| Textbox - Shape | Excel Programming | |||
| Editting textbox value that is grouped with a shape | Excel Programming | |||
Linear Mode
