Shape sizes set by cell values

  • As shown on the attached file forum.ozgrid.com/index.php?attachment/61865/, I need the diameters of four circles to be set by the values in four cells.


    A thread on here from 2007 led me to put this Formula into D2. It sets the size of shape "Oval 14" based on a value in cell C2:


    =udfSizeCircle("Oval 14",C2)


    The Function is then added to a module:



    What I can't work out is how to "cycle" through multiple shapes so each one is sized by a different cell.


    The file has a "static example" on the RHS showing what I want to achieve.


    All suggestions received gratefully


    Ochimus

Participate now!

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