How to remove a drawn chart object using VBA.

[Raas]

I have a school project that requires me to draw a polygon on a chart
(through VBA), then using a macro button, change the points of the polygon
and re-draw it. I must eliminate the first polygon before, or immediately
after drawing the second one. This way it will look like it's rotating
around an axis. I have the points drawn, I have the polygon filled in with
color. I can rotate the nodes if I use CNTL =. I need to be able to press a
button, have CNTL plus = function properly, then remove the first polygon and
draw the next one.

Help anyone?

 

[Andy Pope]

Hi,

Jon Peltier has a page detailing drawing polygons on charts which should
prove useful reading.
http://peltiertech.com/Excel/Charts/VBAdraw.html

Cheers

 

[Raas]

Good try, but this link only showed how to draw the polygon, not delete and
redraw. I do appreciate the information for other purposes however. I did
figure it out myself. Thanks

 

[Andy Pope]

I assume then that you worked out you need something like.

Activechart.Shapes(1).Delete