Checkbox won't delete

**foxguy** · 08-23-2010, 07:11 PM

I'm using this code to delete all checkboxes below a given top.

Please Login or Register  to view this content.

No matter what I do, it always leaves one checkbox. It deletes all the others, but always leaves one.

**shg** · 08-23-2010, 07:26 PM

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

**foxguy** · 08-23-2010, 09:56 PM

Hi shg;

I don't want all the checkboxes deleted. Only those that are below a fixed point on the screen. The code I'm using works fine except that there is always one checkbox left below that point.

**foxguy** · 08-23-2010, 10:20 PM

I found a solution to my problem. I named the checkboxes when I created them with a unique name pattern, then deleted all the checkboxes with that name pattern.

Please Login or Register  to view this content.

I'm still interested in finding out why my first code doesn't work.

**MarvinP** · 08-24-2010, 12:21 AM

When you create controls, isn't the first one a count of zero? Have you tried

for i = 0 to ......

**romperstomper** · 08-24-2010, 02:29 AM

Generally better to loop backwards through a collection when deleting. The need for an error handler is a bit of a giveaway.

**foxguy** · 08-24-2010, 05:01 PM

romperstomper; that's probably it. Don't know why I didn't think of it.

MarvinP - yes I tried from 0 to, didn't make any difference.

**MarvinP** · 08-24-2010, 07:12 PM

Perhaps it is like hiding pages. You can't hide the last page because then you''d have none? Just a stupid guess. Have you treid the immediate window to see which checkbox is still there? Use the index method to see which it is. Maybe this will give you a clue.