Excel checkbox data being cached?

[MrTeeny]

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

 

[Zot]

I think it is related to the vba script on how it was written. Anyway, each time you add CheckBox to a sheet or Userform by default it is named sequentially as CheckBox1, CheckBox2, and so on if they are on same sheet. If new sheet, the number starts from 1 again.

 

[Lian]

I guess there is a veryhidden worksheet to save to value of checkbox.

 

[Zot]

I guess there is a veryhidden worksheet to save to value of checkbox.

The CheckBox is only Boolean. I believe the state it was at during time the file was saved will stay.

 

[MrTeeny]

I think it is related to the vba script on how it was written. Anyway, each time you add CheckBox to a sheet or Userform by default it is named sequentially as CheckBox1, CheckBox2, and so on if they are on same sheet. If new sheet, the number starts from 1 again.

Thanks, so guess it must be being stored somewhere or other within the xlsm file.