You could take another approach, link all 3 buttons to the same cell, say
A1, and add this formula to A1
=IF(F1="",1,IF(F1=30,2,IF(F1=60,3)))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Claud Balls" wrote in message
...
Private Sub CommandButton1_Click()
If ActiveSheet.Range("A6") = "" Then
OptNoL.Value = True
ElseIf ActiveSheet.Range("A6") = 30 Then
opt30L.Value = True
ElseIf ActiveSheet.Range("A6") = 60 Then
opt60l.Value = True
End If
End Sub
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!