Ilino
XLDnaute Barbatruc
Bonsoir forum,
je souhaiterai simplifie le code ci dessous .
GRAZIE
je souhaiterai simplifie le code ci dessous .
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If [L41] = "Oui" Then [N41] = "Non"
If [L43] = "Oui" Then [N43] = "Non"
If [L45] = "Oui" Then [N45] = "Non"
If [L47] = "Oui" Then [N47] = "Non"
If [L49] = "Oui" Then [N49] = "Non"
If [L51] = "Oui" Then [N51] = "Non"
If [L53] = "Oui" Then [N53] = "Non"
If [L55] = "Oui" Then [N55] = "Non"
If [L57] = "Oui" Then [N57] = "Non"
If [L59] = "Oui" Then [N59] = "Non"
If [L61] = "Oui" Then [N61] = "Non"
If [L63] = "Oui" Then [N63] = "Non"
If [L65] = "Oui" Then [N65] = "Non"
If [L67] = "Oui" Then [N67] = "Non"
If [L69] = "Oui" Then [N69] = "Non"
If [L71] = "Oui" Then [N71] = "Non"
If [L73] = "Oui" Then [N73] = "Non"
If [L77] = "Oui" Then [N77] = "Non"
If [L79] = "Oui" Then [N79] = "Non"
If [L81] = "Oui" Then [N81] = "Non"
If [L85] = "Oui" Then [N85] = "Non"
If [L87] = "Oui" Then [N87] = "Non"
If [L89] = "Oui" Then [N89] = "Non"
If [L91] = "Oui" Then [N91] = "Non"
If [L93] = "Oui" Then [N93] = "Non"
If [F21] = "Non" Then [H21] = "Pas d'ouvrage"
If [F23] = "Non" Then [H23] = "Pas d'ouvrage"
If [F25] = "Non" Then [H25] = "Pas d'ouvrage"
End Sub