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

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

Rick

"thread" wrote in message
...
Hi all
does anyone have examples of vba code that adding vba code line?

Dim StartLine As Long

With ActiveWorkbook.VBProject.VBComponents("Module1").C odeModule
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)



"thread" wrote in message
...
Hi all
does anyone have examples of vba code that adding vba code line?

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

RBS


"thread" wrote in message
...
Hi all
does anyone have examples of vba code that adding vba code line?

On 5 פברו�ר, 23:50, "RB Smissaert"
wrote:
All explained nicely hehttp://www.cpearson.com/excel/vbe.aspx

RBS

"thread" wrote in message

...



Hi all
does anyone have examples of vba code that adding vba code line?-הסתר טקסט מצוטט-

-הר�ה טקסט מצוטט-

thank you very much