VBA Coordinates

Hi

Im relatively new to VBA and as part of my final year project in college I have to create animations of mechanisms in excel for educational purposes. How does the coordinate system work when inserting a shape, I cant find any information on it? I know a A screen position has an X and a Y coordinate, with X increasing to the right and Y increasing downward. The origin (0,0) is the top left corner of the worksheet. how does that relate to top and left in code in VBA?

Thanks

Paul

Cell A1 has a .top of 0 and .left of 0. The .width and .height denote the size of the cell from which the .top and .left of the adjacent cells is determined.

So if you have a shape that you want to put in A1 and then move across each cell one at a time:

Please Login or Register  to view this content.

and so on

Ah I see!

Thanks for the help!