Rotate Autoshape Line

  • Hello All.


    I'm trying to write some code to rotate a line by an amount specified in a cell. Each time this amount changes I want the bottom of the line to remain fixed so the line acts rather like that on a speedometer etc. However, the line moves each time and I can't work out the logic or how the AddLine parameters work and am stumped as to how to achieve this.


    Please could anyone help?


    My code so far is below:


  • Re: Rotating Autoshape Line


    Just merged some code form here: http://www.ozgrid.com/forum/showthread.php?t=30075


  • Re: Rotating Autoshape Line


    I just figured it might get you on the right path. I'm leaving work in about 2 minutes, but if you haven't gotten by tomorrow I'll play around with it too.


    I can see some nice uses with this. I've never used the autoshapes, but this could be modified to generate a "simpler" version of an Xcelsius report maybe. I don't know, good luck.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!