I have a vba script that adds checkboxes to a sheet I use for betting. Each time it switches to a new market the checkbox data gets incremented by one rather than starts at 1 i.e. once a race with say 5 runners has finished it moves to a new market but that now starts adding checkboxes with number 6 and so one. It's now in the 20 thousands, does excel cache checkbox data or any other caches saving data somewhere along with the sheet? And can I clear that data as it's obviously being saved with the sheet or excel itself.
Thanks
Thanks