Multiple Checkbox Change w/ VBA Won't work w/ out msgbox

I have an interesting problem I can't figure out. I have a userform where the user can select which tabs to display, each tab having a cooresponding checkbox. I do a simple if statement to change the passed value of TRUE or FALSE.

If I run it without a msgbox at the end, it changes one check box at a time everytime you click the "Select All" or "Select None" buttons. However, if I add a msgbox at the end, it works fine. I can just leave the msgbox in for now, but it's somewhat of a nusiance.

Any suggestions would be greatly appreciated.

Please Login or Register  to view this content.

in the code example, it would change one value every time you click the button, remove the comment from the msgbox, and it works fine. Weird.