VBA for shapes

[jackso]

A spreadsheet has a selection of five countries on a map (shape on the spreadsheet.) On selection of a shape, data is calculated from inputs worksheet onto output worksheet.

I have a couple of queries :
1) where do the names "Rectangle" and "Freeform" come from as they are not defined anywhere.
2) also, what is the code referring to f.left, width etc doing?

Thanks in advance

Please Login or Register  to view this content.

[xladept]

Hi,

Rectangle and Freeform are Default names for the shapes and are assigned to f and r respectively.

Please Login or Register  to view this content.

Positions the rectangle(with text) half the difference of the two shapes to the left of the freeform.

[jackso]

Thanks for this and your prompt reply. It is starting to make more sense now.

[xladept]

You're welcome!