Comparer la partie majuscule d'une cellule a la partie majuscule d'une autre cel

Private Sub CommandButton2_Click()
Dim colA As String
Dim colB As String
colA = majuscules(Range("A1"))
colB = majuscules(Range("B1"))
If colA = colB Then
MsgBox "egal"
Else
MsgBox "pas egal"
End If
End Sub
Public Function majuscules(zone)
Dim sel As Object
Dim i As Integer
Application.Volatile
For Each sel In zone
For i = 1 To Len(sel)
If Asc(Mid(sel, i, 1)) > 64 And Asc(Mid(sel, i, 1)) < 91 Then
majuscules = majuscules & Mid(sel, i, 1)
End If
Next i
Next sel
End Function

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim maj As String
If Not Application.Intersect(Target, Range("A:A")) Is Nothing Then 'adapter la colonne
maj = majuscules(Range(Target.Address))
Target.Value = Replace(Target.Value, maj, "")
Target.Value = maj & " " & Target.Value
End If
End Sub
Public Function majuscules(zone)
Dim sel As Object
Dim i As Integer
Application.Volatile
For Each sel In zone
For i = 1 To Len(sel)
If Asc(Mid(sel, i, 1)) > 64 And Asc(Mid(sel, i, 1)) < 91 Then
majuscules = majuscules & Mid(sel, i, 1)
End If
Next i
Next sel
End Function