excel - How to delete only 1 checkbox from any particular cell? -

how delete 1 checkbox particular cell(say in "c38") using excel vba?

here little guide how delete specific shape

as can see, selecting shape show name in name box (placed on left side of formula box). in above example, name of selected shape rectangle 1
if want delete specific shape have know name (well, if unless it's specific shape has own properties different other shape not cover in here)
easiest way name of shape want delete it's click on shape , name in name box.
once know name can modify current code , add if statement match on 1 item shapes collection.

sub deleteshape()     dim vshape     each vshape in activesheet.shapes         if strcomp(cstr(vshape), cstr("rectangle 1"), 1) = 0             vshape.delete             exit         end if     next end sub