Help with Checkboxes on userform

[dunez]

Hi!
Here's the scenario: I want to have multiple check-boxes on my user form (around 16 options) but I can only have 4 selected that will go into either column F,G,H or I. It doesnt matter which they go into, but it thats where they need to go. I am fairly new to vba and have no idea the code needed for this. Right now I am using comboboxes but I need a way to ensure that the same person is not selected twice, hence why I thought check boxes may be a better option!
Hope that makes sense!
Thanks in advance!

 

[Leith Ross]

Hello dunez,

Your best option is to use Frames and Option buttons (also known as Radio buttons). These can be grouped in 4 separate groups using separate Frame objects. This will make each group independent of the others selections. The buttons are by design mutually exclusive (only one may be chosen at a time).