Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Count = 1 Then
If .Value <> "" Then .Value = UCase(.Value)
End If
End With
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Count = 1 Then
If Not IsNumeric(.Value) Then .Value = UCase(.Value) 'parce les chiffres ne connaissent pas les majuscules
'ni les minuscules d'ailleurs ;-)
End If
End With
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
.Value = IIf(.Count = 1, UCase(.Text), .Value)
End With
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
.Value = IIf(.Count = 1, StrConv(.Text, vbUpperCase), .Value)
End With
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
.Value = IIf((.Count = 1 And Not IsDate(.Value)), UCase(.Text), .Value)
End With
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Areas.Count > 1 Then Exit Sub
With Target
If .Count = 1 Then
If Not IsDate(.Value) Then
If Not .HasFormula Then
.Value = UCase(.Value)
End If
End If
End If
End With
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Areas.Count > 1 Then Exit Sub
With Target
.Value = IIf(.Count = 1 And Not IsDate(.Value) And Not .HasFormula, UCase(.Text), .Value)
End With
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Count = 1 Then
If .Value <> "" And Not IsDate(.Value) Then .Value = UCase(.Value)
End If
End With
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim C As Range
Application.EnableEvents = False
For Each C In Target
If C.HasFormula = False Then 'afin de ne pas affecter les formules
C.Value = UCase(C.Value)
End If
Next
Application.EnableEvents = True
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
'code VBA avec IIF
Application.EnableEvents = True
End Sub