Shape sizes set by cell values

  • As shown on the attached file, 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


Participate now!

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