Scrollbar Name

In the file I attached, in Class CChk, the Sub MyChk_Click will handle the Click event from any checkbox. It then calls a Sub SingleCheck in whatever module owns the checkbox and passes in the checkbox name. If you take the file I attached and change all occurrences of CheckBox to ScrollBar it may work, I haven't tried it to confirm.

Note that Sub UserForm1.UserForm_Initialize sets up the collection of checkboxes to begin with, necessary for this scheme to work. It's easy in a userform because you can use the Initialize method. If your controls are in a worksheet, we would have to move this to the ThisWorkbook.Workbook_Open sub.

If you need additional help, attach your file.

Originally Posted by 6StringJazzer

In the file I attached, in Class CChk, the Sub MyChk_Click will handle the Click event from any checkbox. It then calls a Sub SingleCheck in whatever module owns the checkbox and passes in the checkbox name. If you take the file I attached and change all occurrences of CheckBox to ScrollBar it may work, I haven't tried it to confirm.

Note that Sub UserForm1.UserForm_Initialize sets up the collection of checkboxes to begin with, necessary for this scheme to work. It's easy in a userform because you can use the Initialize method. If your controls are in a worksheet, we would have to move this to the ThisWorkbook.Workbook_Open sub.

If you need additional help, attach your file.

Great! I will give that a try aveand get back to you...thanks so much for the help