View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default How to draw a object and erase it programmatically

You may want to group the circle and rectangle and instead of deleting, just
move them.

You could even add them multiple times and then toggle the visibility.



Simon Lenn wrote:

I want to draw a rectangle with a circle programmatically and then I
want to erase and draw the rectangle and circle at a different place
on the worksheet.

Appreciate if somebody can share the code segment for a routine for
this.

Thanks
Simon


--

Dave Peterson