ive attathed the file. the the probs are with the bits under the 'targets met?' section

Can you be more spefic? I've downloaded your XL file and need for info (do you want the option buttons to respond as true/false or ?)

hi,
i need it 2 reply as yes or no. i think i need an IF formula to go with the 1 and 2 as the original prob is sorted

See the attached sample. Note that I've placed VBA Yes/No option buttons into a Group Box to isolate them and prevent them from reacting with any other option buttons on the sheet. Then in VBA code in sheet 1 I've used this code:

Private Sub optNo1_Click()
Dim n
n = "No"
If optNo1.Value = True Then
Sheet1.Cells(4, 5) = n
End If
End Sub

Private Sub optYes1_Click()
Dim y
y = "Yes"
If optYes1.Value = True Then
Sheet1.Cells(4, 5) = y
End If

End Sub

Replicate this for your second set of option buttons and your there


Merry Christmas