Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2.  
  3. If (Target.Count = 1) Then
  4.     If (Target.Style.Name = "OuiNon") Then
  5.         Target.Offset(0, -1).Value = "Oui"
  6.     End If
  7. End If
  8.  
  9. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement