Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub CommandButton1_Click() ActiveCell.Offset(0, 1).Range("A1").Select If EIGoui.Value True Then EIG "OUI" If EIGnon.Value True Then EIG "NON" ActiveCell.Value = EIG End Sub Private Sub EIGnon_Click() ActiveCell.Offset(0, 1).Range("A1").Select If EIGnon.Value True Then EIG "NON" ActiveCell.Value = EIG End Sub Private Sub EIGoui_Click() ActiveCell.Offset(0, 1).Range("A1").Select If EIGoui.Value True Then EIG "OUI" ActiveCell.Value = EIG End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next If Target.Value = "OUI" Then UserForm1.EIGoui.Value = True UserForm1.EIGnon.Value = False End If If Target.Value = "NON" Then UserForm1.EIGoui.Value = False UserForm1.EIGnon.Value = True End If End Sub
Private Sub EISnon_Click() FrameEIG.Visible = False End Sub Private Sub EISoui_Click() FrameEIG.Visible = True End Sub