drawing autoshapes according to cell value

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?

YEs call the procedure from the worksheet_change event


eg:

Please Login or Register  to view this content.

Originally Posted by stevebriz

YEs call the procedure from the worksheet_change event


eg:

Please Login or Register  to view this content.

Steve,

Is there any way doing this stuff without macro

Humility

Originally Posted by stevebriz

YEs call the procedure from the worksheet_change event


eg:

Please Login or Register  to view this content.

Thanks for the answer I try that out. I just suspect that won't work for me, let me explain why. I have one excel file full of measurement results and the macro that I use is stored into another excel file. The values are read from the measurement excel file and an extra worksheet is created to that excel file as a conclusion of the measurements. If the macro is not stored in the excel file, can that event macro work? I guess not. Anyhow I'll try it out and let you know if it worked for me.

The macro you showed doesn't seem to respond to any evant in A1, not even if I have the macro stored to the sheet where I make the chagnes. Is there some settings I need to change in Excel to allow this to work? Here's my code:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$1" Then 'Call DrawStars
MsgBox ("change detected")
End If

End Sub