Private Sub obG1()
UserForm1.Frame2.Visible = UserForm1.OptionButton2.Value
If Me.OptionButton1.Value = True Then
For x = 1 To 11
Me.Controls("TextBox" & x).Value = ""
Next x
Me.TextBox1.SetFocus
nl = 0
End If
'TextBox11.Value = ActiveSheet.UsedRange.Rows.Count
'ou bien
'TextBox11.Value = Application.CountA(Range("A:A"))
End Sub