Bon j'ai ça comme formule:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [G5:G65536]) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target = UCase(Target)
If Intersect(Target, [K5:K65536]) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target = UCase(Target)
If Intersect(Target, [O5:O65536]) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target = UCase(Target)
Application.EnableEvents = True
End Sub
Malheureusement, seulement une des trois devient en majuscule =(
Que faire?
J'attend vos lumières! =)
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [G5:G65536]) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target = UCase(Target)
If Intersect(Target, [K5:K65536]) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target = UCase(Target)
If Intersect(Target, [O5:O65536]) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target = UCase(Target)
Application.EnableEvents = True
End Sub
Malheureusement, seulement une des trois devient en majuscule =(
Que faire?
J'attend vos lumières! =)