Sub macro()
Dim Debut&, Fin&, i&, TexteMacro$
With ThisWorkbook.VBProject.VBComponents("Module1").CodeModule
Debut = .ProcStartLine("macro1", vbext_pk_Proc)
Fin = .ProcCountLines("macro1", vbext_pk_Proc) + Debut
For i = Debut To Fin
TexteMacro = TexteMacro & .Lines(i, 1) & Chr(10)
Next
End With
MsgBox TexteMacro
End Sub
Sub macro1()
sMessage = "hello"
sMessage = sMessage & ", world !"
MsgBox sMessage, vbInformation, "MESSAGE"
End Sub