Sub Test()
Dim FORME As String
Dim x As Long
For x = 1 To ActiveSheet.Shapes.Count
FORME = ActiveSheet.Shapes(x).Name
'Ne boucle que sur les "Boutons"
If ActiveSheet.Shapes(x).Type = 8 Then
'affiche la "caption" du bouton en supprimant le ¦ et l'espace
MsgBox _
Right(ActiveSheet.Shapes(FORME).[B]TextFrame.Characters.Text[/B], _
Len(ActiveSheet.Shapes(FORME).TextFrame.Characters.Text) - 2)
End If
Next x