How to copy properties from one shape to another

  • Thread starter EducationCoordinator
  • Start date
E

EducationCoordinator

I have a set of planting maps with plant names and other information stored
in the custom properties of a callout box shape. I want to take the
properties from one callout box and put them into the custom properties of a
second callout box. I cannot figure out the syntax.

I would appreciate any help with this!
 
D

David Parker

Usually, the plant would have the data and the callout would just display
it.
Are you sure you have it the other way round?
 
E

EducationCoordinator

Yes. The information is in the callout box.
I need to know the syntax for (as an example) taking the text contents of a
property called BotanicalName from one shape and making the text contents of
property BotanicalName in another shape equal to this string.

Any help with the syntax?
Thank you
 
D

David Parker

Something like?

shapeA.cells("Prop.BotanicalName").Formula =
shapeB.cells("Prop.BotanicalName").Formula
 
E

EducationCoordinator

I thank you so much! I have several hundred shapes with information I wanted
copied to a new shape, and I was able to automate that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top