Only 1 option to be selected in userform

Hi,

1. Use three Option Buttons instead of Check Boxes. Then you can avoid the CommandButton altogether. Use the Click event of each option button to set the cell value to T, A or C. e.g.

Private Sub OptionButton1_Click()
    Selection = "A"
    Unload frmSelectionOption

End Sub

This also deals with item 3 since the form will shut down after the Option button is clicked.

To restrict the range create two range names 'Range1' and 'Range2' and use the sheet Double click event event. i.e.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Not Intersect(Target, Range("Range1")) Is Nothing Or Not Intersect(Target, Range("Range2")) Is Nothing Then

        frmSelectionOption.Show

    End If

End Sub

Hi,
See if this update to your workbook does what you want.

Dave

Edit:

In CommandButton1_Click I omitted line

 Unload Me