Background: I have an Excel 2007 database with around 500 lines, each of which has a couple of user interface checkboxes (user form types, each located in a cell in its respective row).
I occasionally need to refresh (delete and recreate) all of these checkboxes and have a macro that successfully does so, sort of.
Problem: Instead of the default checkbox numbers for the new set being checkbox1 to checkbox1000 again, they continue on from the previous total; I’m up to almost 40,000 now. While I can only see and interact with the latest batch, the rest are still there somewhere and the deletion macro cycles through all 40,000 of them (it will be 41000 next time).
Using VBA how do I permanently eradicate the unwanted checkboxes?
The code I’m using now selects each in turn and then delete’s it ( cb.delete where cb is set to the checkbox).
Thank you.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!