Salut Deborah, salut le forum,
Voici ta macro modifiée qui devrait faire ce que tu demandes.
Sub MACRO1()
Dim text As String
ActiveSheet.Shapes("Rectangle 1").Select
text = Selection.Characters.text
ActiveCell.Select
ActiveCell.Value = text
With Selection.Interior
.ColorIndex = 39
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
ActiveCell.Offset(0, 1).Select
End Sub
À plus,
Robert