I've created a VBA macro that generates 3D rotated cubes of different proportions.

The 3D rotation is performed by the "Off Axis 2 Top" rotation function.

In the code and picture below is a simplified illustration of the reference nodes. Green nodes indicate the corner positions before the rotation, while the red nodes are what I wish to find so that I can add text/arrows etc. to these locations everytime a new cube is generated by the macro.

I can use transformation and rotation matrices to find these locations, but is there a simple way to just return the X, Y positions of each corner as it is stored?

Please Login or Register  to view this content.
Thank you for any help.

Capture.JPG