Copy a TextBox (shape)
 

Leith -

I'm not sure, its the type that you can create in Excel 2007 ...
Insert/Text/TextBox.

Mark

"Leith Ross" wrote:


OssieMac;208941 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




Hello Mark,

"Shapes" is a very broad class. It would save a lot of time if we knew
which of three types of text boxes you wanted to copy: HTML, Forms, or
Control Toolbox.


--
Leith Ross

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/)
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57318