Increment through Checkbox's to check status and change a value

I have a userform that has 28 checkbox's that we go through that we check which ones apply to a report.. To keep those boxes checked as the supervisor's cycle through the reports, I am leaving a 28 digit code next to the report which is created as they check/uncheck the proper checkbox's.


I have been trying to research it a bit and can't find the code that I require. I hope below explains what I am looking for.

Please Login or Register  to view this content.

So if say CheckBox10.value = True, then the 10th digit of the ID will change to 1 while keeping the rest of the ID the same.


Thanks in advance.

Please Login or Register  to view this content.

there may be an easier way :o)

Thanks for your input. After a little more research and what you guys have provided, I was able to come up with the following which works like a charm.

Please Login or Register  to view this content.

Thank you, that should help in case there is a space in there that I can't see...