Bonjour,
Il faut que tu ajoutes un test dans ton code
Private Sub ListBox1_Click()
Dim VOTE As String
On Error Resume Next
If Me.OptionButton1 = True Then
VOTE = "Pour"
ElseIf Me.OptionButton2 = True Then
VOTE = "Contre"
ElseIf Me.OptionButton3 = True Then
VOTE = "Abstention"
End If
With ListBox1
If Cells(.List(.ListIndex, 1), 3) <> "A" Then
Cells(.List(.ListIndex, 1), 1).Select
Cells(.List(.ListIndex, 1), 4) = VOTE
End If
End With
Unload Me
UserForm2.Show 0
End Sub
A+