I am making a userform that will have a varied amount of checkboxes dependent on how many worksheets there are. I 've programmed it so that for each worksheet, userform.controls.add a checkbox. Now, my problem with this is that (at least in VBA6) .caption is not a property of a Control. So when I set the .caption of each checkbox, I get an automation error. Is there a way to set the caption on a Control that is created by VBA? Otherwise, I'll just create a bunch of checkboxes and just make them visible or not. I'd rather not do this, but I could.

Nick.