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

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 and
I will have a look into.

Wkr,

JP


"Rachel" wrote in message
...
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

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" wrote:

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

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

Cheers :)

"JP Ronse" wrote:

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 and
I will have a look into.

Wkr,

JP


"Rachel" wrote in message
...
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


.