Help with check boxes!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • VBA Novice
    New Member
    • Jun 2007
    • 1

    Help with check boxes!

    I am working on a form and I need to have a check box be able to check off if a check box to the right of it is checked off, but I am not looking for the vice versus effect. Please help step-by-step.

    Thanks
  • pureenhanoi
    New Member
    • Mar 2007
    • 175

    #2
    Originally posted by VBA Novice
    I am working on a form and I need to have a check box be able to check off if a check box to the right of it is checked off, but I am not looking for the vice versus effect. Please help step-by-step.

    Thanks
    there is no effect that u want. Do it by code
    Put into ur form two checkboxes and named it: chkRight and chkLeft
    Double click in chkRight to open code editor.
    Write ur code like this
    Code:
    Private Sub chkRight_Click()
         If chkRight.Value = 0 Then    'right-checkbox is off
               chkLeft.Value = 0           'then check-off the left
         End If
    End Sub

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      Originally posted by VBA Novice
      I am working on a form and I need to have a check box be able to check off if a check box to the right of it is checked off, but I am not looking for the vice versus effect. Please help step-by-step.

      Thanks
      Before asking for code ,u need to post how u have tried to solve it.

      Comment

      Working...