adding code lines with vba code

[thread]

Hi all
does anyone have examples of vba code that adding vba code line?

 

[Rick Rothstein \(MVP - VB\)]

I think you may have to provide us with a more detailed description of what
you are trying to do.

Rick

 

[Bob Phillips]

Dim StartLine As Long

With ActiveWorkbook.VBProject.VBComponents("Module1").CodeModule
StartLine = .CountOfLines + 1
.InsertLines StartLine, _
"Sub TestProc()" & vbCrLf & _
"Dim ans" & vbCrLf & _
" ans = Msgbox( ""All OK"",vbYesNo)" & vbCrLf & _
" If ans = vbNo Then Cancel = True" & vbCrLf & _
"End Sub"
End With


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[RB Smissaert]

All explained nicely here:
http://www.cpearson.com/excel/vbe.aspx

RBS

 

[thread]

All explained nicely here:http://www.cpearson.com/excel/vbe.aspx

RBS






-הר××” טקסט מצוטט-

thank you very much