You can make a check box look like an option button by deselecting the other
boxes when one comes true


Private Sub CheckBox2_Click()
if checkbox2 = true then
checkbox1 = false
checkbox 3 = false
end if
End Sub



"Dave Peterson" wrote:

That's the way checkboxes work.

Maybe you meant to use OptionButtons -- they'll only allow one option to be
chosen in each group.



RyanH wrote:

I have 4 Checkboxes in a UserForm. I have given all 4 Checkboxes the
GroupName = "Shipping" in the Properties Window in the VBA Editor. We I Show
the UserForm and click on one Checkbox the others do not turn off, why?

Thanks in Advance,
Ryan

--

Dave Peterson