Checkboxes are like Tribbles!

[Xipha]

Ok, so I hate using checkboxes, but in this case I don't have a choice (The sheet was designed by someone else and has a ton of checkboxes that don't line up with individual cells, I am just writing some macros for it)

So the macro copies a template worksheet, but when it does, every checkbox is copied twice, sometimes three times and the copies say "Check Box 114" etc next to them, which totally messes up how the sheet is supposed to look. I can't tell the macro to delete just the duplicates because then I would have to refer to them by name, and the names are not constant. I am beyond frustrated right now. Why does this happen, and how can I fix it? (I am using Office 365, you think they would have worked out the bugs in checkboxes by now.....)

Thanks

 

[Jerry Sullivan]

Hi and Welcome to the Board,

Nice thread title! I haven't observed Checkboxes multiplying on their own. Is it possible that the checkboxes were already duplicated before the template worksheet was copied, or perhaps the macro is making the duplicates?

If you still need to clean up the file, it's feasible to write some VBA code that will find and eliminate duplicates.

Just ask if you want some help with that.

 

[elncid]

Hi,

I am using Office 365 as well and have run into the same trouble. I am the designer of the form, so would like to get some help if I can avoid using checkboxes altogether!

Regards,

elncid