Change Checkbox Caption After Userform Activation

I'm curious if it is possible to change a caption once a userform loads. Specifically for a checkbox. I have a series of checkboxes in a userform which are used to filter the contents of a combobox and i want the caption of each to contain a number which indicates its quantity in the combobox, which is a number that would be affected by other checkboxes being checked or not. So when a checkbox is checked i want all the checkbox captions to be updated and I thought I wrote the code to do this perfectly, but it only works at the initial activation of the userform, and I can't seem to change the captions at all while the userform is active. Is it even possible?

Try:

Please Login or Register  to view this content.

Lewis

thanks I figured it out