How can insert Module in VBE by VBA ?

[sthanawa]

Dear All ,

I would like to know how can I insert MODULE in visual basic editor by VBA code ?

 

[acw]

Hi

Have a look at

http://www.cpearson.com/excel/vbe.htm

Some good examples on how to use code to program code.


HTH

Tony

 

[sthanawa]

I have try to run the code as your advise , but I found error "Can't enter break mode at this time" at the line .InsertLines LineNum, _

How can I solve this error ?

Sub AddProcedure()

Dim VBCodeMod As CodeModule
Dim LineNum As Long

Set VBCodeMod = ThisWorkbook.VBProject.VBComponents("NewModule").CodeModule
With VBCodeMod
LineNum = .CountOfLines + 1
.InsertLines LineNum, _
"Sub MyNewProcedure()" & Chr(13) & _
" Msgbox ""Here is the new procedure"" " & Chr(13) & _
"End Sub"
End With

Application.Run "MyNewProcedure"

End Sub

 

[northwolves]

You need to add Reference to "Microsoft Visual Basic For Applications Extensibility 5.3"