autoshape resized based on data fields

[kmorlatt]

Hi! I did ask this question at below and rec'd very good solution(s) that I tried however still not working for me.
Question: After inserting a round autoshape into excel...would like it to grow/shrink based on a number in a 'related' data field...for instance if I change the number in a field from 100 to 50 the round autoshape shrinks and visa versa...something like the pubil of an eye.
http://www.eggheadcafe.com/community/excel/66/10405424/autoshapesdata-fields.aspx
Thank you very much!

[Sisyphus]

Hi,
I tried my hand at this and attach the result. This is how I approached the problem:
Excel places the Autoshape relative to a fixed Top, defining its upmost limit, and a fixed Left which defines its leftmost extension. As the shape - in this case a circle - grows or shrinks its center moves. I thought that you would want the center to remain in place. Therefore the Top and Left had to be adjusted in accordance with the diameter of the circle.
Increase or decrease is defined as a percentage. 100% is the original size, 0% shrinks the circle to a dot, and any other percentage is relative to the original size. You can adjust this original size to any value you want, so long as its diameter is smaller than the fixed Left. When you deploy the system you may not want to define the original size on the worksheet. Well, that will save the code of reading the worksheet. Same for the Left and Top properties which I set arbitrarily, much like the diameter. You can adjust them to anything you want and keep the original values anywhere you want, but you need these three "original" parameters. On the attached sheet I have placed the 100%-sized circle in a frame. This is just to show that the center doesn't move.
I hope, this is what you wanted.