Position text boxes based on table of text box parameters

[jprlimey]

With the following code i'm trying to copy and paste text boxes (shapes) from one sheet to another, however i want to locate the text boxes based on values on another sheet, for example, below is an abbreviated list from sheet named "TextBoxes".

I also want to dynamically set the array to the text box names list in column A of the sheet named "TextBox", see attached image below for text box table

textboxtable.PNG

So the text boxes are copied from sheet named "Data", then pasted onto sheet named "Planning", then the location of the text box is defined by corresponding text box name in columns B thru E on the sheet named "TextBox"

It would appear that i'm having difficult setting the array, and i know that the method to set the text box location isn't correct either.

Any help would be appreciated

Please Login or Register  to view this content.

[Andy Pope]

Please Login or Register  to view this content.

You need to make sure the values in the table are setting the correct properties of the shape.
According to the table the first value is Left but you set the shapes Top property.
The tables second value is Right which is probably just a typo.

[jprlimey]

Andy,

You are a genius!!

The solution worked great. I did end up changing the text box naming routine to capture Left, Top, Height and Width and everything worked perfectly.

Thanks vey much for your help.