Option Explicit
Sub Bouton1_Cliquer()
Dim Sh1 As Worksheet, Sh2 As Worksheet
Set Sh1 = Worksheets("Feuil1")
Set Sh2 = Worksheets("Feuil2")
Sh2.Range(Sh2.Cells(5, 2), Sh2.Cells(5, 2)).NumberFormat = "@": Sh2.Cells(5, 2) = "000" & Sh1.Cells(3, 2) & "-" & Sh1.Cells(4, 2)
MsgBox "Eurêka !", vbExclamation, "Super....."
End Sub