Is there a way to draw x number of autoshapes according to a cell value? For example if A1 = 2 then the worksheet contains 2 autoshape objects and if I change the value to 5 the page has 5 autoshape objects. I know how I can do it with Macro, but I'd like excel to do it on the fly (formula kind of way), without running the macro everytime the value in A1 changes.

Or is there a way to start a function automatically everytime the value in cell A1 changes?