Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
ActiveCell.Value = Left(ActiveCell.Value, 2)
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim TabTemp, i As Integer, Chaine As String
TabTemp = Split(Target, " ")
For i = LBound(TabTemp) To UBound(TabTemp)
Chaine = Chaine & Left(TabTemp(i), 1) & " "
Next
Target = Chaine
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim Lg, i As Integer, Initiale As String, Cible As Variant
Cible = ActiveCell.Value
Lg = Len(Cible)
Initiale = Left(Cible, 1)
If Lg > 2 Then
For i = 2 To Lg
If Mid(Cible, i - 1, 1) = " " Then
Initiale = Initiale & Mid(Cible, i, 1)
End If
Next i
End If
ActiveCell.Value = Initiale
End Sub
comme ceci peut-être ?Bonjour,
je souhaite par macro, et sur simple doucle clic, changer la valeur de la cellule activée par les initiales de chaque mot qu'elle contient...
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim x$, i!
x = Left(Target, 1)
For i = 1 To Len(Target)
x = x & IIf(Mid(Target, i, 1) = " ", Mid(Target, i + 1, 1), "")
Next
Target = UCase(x)
End Sub