View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nicole D. Nicole D. is offline
external usenet poster
 
Posts: 5
Default Why doesn't this work

I created a form in excel and when the user clicks on a checkbox I want
option button to default to true or false. I wrote the following statement:

Private Sub chkQAuto_Click()

If chkQAuto.Value = False Then
optDe3.Value = True And optAsir3.Value = True
'Else: optDe3.Value = False And optAsir3.Value = False
End If

End Sub

Can someone tell me why it doesn't work?

~Nicole