asked on

Disable CheckBox on UserForm in Excel depending on selections

Hi Experts!

I have a Userform in Excel (2007) with several check-boxes on it. For example, there are 2 categories, each with 5 check-boxes under it. The user needs to check one from checkbox 1-5 (category 1) and one from checkbox 6-10.

Upon selection from any of the checkboxes 1-5, say number 2, then checkbox 1,3,4 and 5 should become disabled.

Many Thanks for the Advice!

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Hello hendrkle,

if a user is allowed only one choice out of many, then typically radio buttons are used instead of check boxes. A group of radio buttons will only allow one of the group to be selected. Check boxes are typically used to allow more than one selection in a group.

cheers, teylyn

hendrkle

ASKER

Thanks teylyn, I don't mind using radio buttons but I run into the problem that only one can be selected, even if I group them into two groups, only 1 from both groups can be selected. However, I wish to have several groups and from each group only one may be selected, so 1 per group but several per userform.

SOLUTION

nutsch

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nutsch

the groupname doesn't matter, only the frame determines the grouping.

ASKER CERTIFIED SOLUTION

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hendrkle

ASKER

Apologies for the delay - it was the in the middle of the night here.

Thanks both for providing the solution to my problem (adding a frame). As requested, all points to teylyn.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Thanks, hendrkle!