Userform checkboxes

[MichelleW]

I need some help with checkboxes on a userform, here is the situation...

I have a userform with a multipage with 5 pages, products. For each product page, there is another 3 page multipage, months. Each month has 5 checkboxes (dates- displayed in the caption) on each page, so 15 checkboxes per product.

Here's what I would like to figure out:
1. I only want to allow one checkbox (date) out of 15 to be checked per product.
2. There is a command button on the userform that once it is pushed, I'd like the one date that was selected per product to be displayed on a sheet within the excel workbook.

Any help would be very appreciated! If I need to supply more info, please let me know, thanks!

[Leith Ross]

Hello MichelleW,

In response to question 1, do not use Check Boxes use Option Buttons. Set the Group property of the option buttons to "Products". This will allow only one of the 15 to be set, regardless of there location on the UserForm.

As for question 2, I would need to see the workbook.