Multiple linked ckeckboxes in Excel 2007

**VanHelsing** · 11-03-2009, 11:03 AM

Hi,

Hi,

I'd lie a little help please regarding Excel 2007 checkboxes. I have 3 of them but I only need one to be checked at a time. Can it be done with VBA automatically?

Thank you in advance.

**mikerickson** · 11-03-2009, 11:09 AM

Options buttons work the way that you want.

**VanHelsing** · 11-04-2009, 02:25 AM

Thank you very much, I got my question answered.
But I have another one: Using radio buttons is excellent but I have 3 different sections, each containing 3 radio buttons and I need those 3 sections to be selected independently.

**mikerickson** · 11-04-2009, 10:23 AM

Are these controls on a userform? If so, the option buttons that are in the same Frame control act as a unit.

If they're on a worksheet, are they Forms controls or ActiveX.
If Forms, the Group Box will identify which option buttons are a unit.

If ActiveX, someone with a PC will have to add their experience for an answer.