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!
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.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks