View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default Active X Checkboxes

Hi

You can change checkbox values by code. Try this:

Private Sub CheckBox1_Click()
Me.CheckBox2.Value = Not (Me.CheckBox1.Value)
End Sub

Private Sub CheckBox2_Click()
Me.CheckBox1.Value = Not (Me.CheckBox2.Value)
End Sub

HTH. Best wishes Harald

"Holanmeg" skrev i melding
...
Is there any way of making check boxes work in the same way as radio

buttons,
i.e. making it possible to be able to only have one box ticked in a group.
You may say use radio buttons, but the users of the form I am constructing
would prefer to have tick boxes.
Many thanks for any assistance.