[VanHelsing]

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.

[OBP]

VanHelsing, welcome to the Forum.
You usually get a quicker and better response to Excel/Access/Word questions if you post on the Business Applications Forum.
But to get back to your question, each Checkbox will need VBA like this one for Checkbox1, I am sure that you can work out the other two.

Private Sub CheckBox1_Click()
If CheckBox1 = -1 Then
CheckBox2 = 0
CheckBox3 = 0
End If
End Sub

[wedonttakecrap]

Hello VanHelsing,

I was wondering why, in this instance, you were using checkboxes instead of a Option (radio) button group? Option buttons only allow one choice to be selected, and saves tedious programming.

A friendly bit of advice to any who may read this: For simple applications of checkboxes and radio buttons, be sure to use the Form Controls from "Developer > Controls > Insert" on the ribbon. It not only saves programming time, but they are not blocked by macro security settings.

happy hacking.

[VanHelsing]

Thank you both 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.

[wedonttakecrap]

First, place a group control. Then place your radio buttons inside the borders of the group control. It's ridiculously easy in 2007, but not terribly intuitive.

The radio buttons will only interact with the other ones in the control borders

Cheers.