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