Sub Renommer()
Dim s As Shape
For Each s In ActiveSheet.Shapes
If s.Name Like "TextBox*" Then _
s.Name = Replace(s.Name, "TextBox", "plouf")
Next
End Sub
Sub RenommeTextBox()
Dim c As Control
For Each c In ThisWorkbook.VBProject.VBComponents("Userform1").Designer.Controls
c.Name = Replace(c.Name, "TextBox", "papou")
Next
End Sub
Sub RenommeTextBox()
Dim tablo, c As Control, n, i
tablo = Array("aa", "bb", "cc", "dd", "ee", "ff", "gg", "hh", "ii", "jj", "kk")
For Each c In ThisWorkbook.VBProject.VBComponents("Userform1").Designer.Controls
If c.Name Like "TextBox*" Then
n = Val(Mid(c.Name, 8, 4)) - 1 'numéro du nom - 1
i = Int(n / 100)
c.Name = tablo(i) & n - 100 * i + 1
End If
Next
End Sub