Option Button Stays selected

[Rachel]

Hi again,
I have 3 option buttons (optDelivery, optPickup and optTable) in a frame
(fraType). All are set to value = False on initialise.
However when optDelivery is selected via click or space bar and then either
of the other 2 are selected optDelivery stays selected.
I need it to only ever be 1 of the 3 as selected.
I have this in userform_initialise:
.... Me.optCash.Value = False
Me.optCheque.Value = False
Me.optCreditCard.Value = False
Me.optDelivery.Value = False
Me.optPickup.Value = False
Me.optTable.Value = False
If Me.optTable.Value = False Then
Me.txtnumberattable.Visible = False
End If

and this in cmdAdd_click()
.... If optDelivery = True Then
ActiveCell.Offset(0, 9).Value = "Y"
ElseIf optPickup = True Then
ActiveCell.Offset(0, 10).Value = "Y"
ElseIf optTable = True Then
ActiveCell.Offset(0, 11).Value = "Y"
End If
If optTable = True Then
ActiveCell.Offset(0, 12).Value = Me.txtnumberattable
End If

Any suggestions???

Thanks once again
Rachel

 

[JP Ronse]

Hi Rachel,

I quickly rebuild your form and paste the code behind and do not have the
issue that the optDelivery stays selected when selecting one of both others.
It is when I drop optDelivery out of the frame. Are you sure they are all 3
in the same frame?

If you don't mind to send the file, you can do it to (e-mail address removed) and
I will have a look into.

Wkr,

JP

 

[FloMM2]

Rachel,
You need to tell your form what you want.
Me.optDelivery.Value = False
If Me.optDelivery = True Then

Me.optPickup.Value = False
Me.optTable.Value = False

End If
If Me.optPickup.Value = True Then

Me.optDelivery.Value = False
Me.optTable.Value = False

End If
If Me.optTable.Value = True Then

Me.optDelivery.Value = False
Me.optPickup.Value = False

End If

hth

 

[Rachel]

Thanks JP and FloMM2.
I adjusted your code a little and it is now working.

Cheers