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" <(E-Mail Removed)> wrote in message
news:c1c9d256-e0d2-47b6-8b7a-(E-Mail Removed)...
> Hi all
> does anyone have examples of vba code that adding vba code line?

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)



"thread" <(E-Mail Removed)> wrote in message
news:c1c9d256-e0d2-47b6-8b7a-(E-Mail Removed)...
> Hi all
> does anyone have examples of vba code that adding vba code line?

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

RBS


"thread" <(E-Mail Removed)> wrote in message
news:c1c9d256-e0d2-47b6-8b7a-(E-Mail Removed)...
> Hi all
> does anyone have examples of vba code that adding vba code line?

On 5 פברואר, 23:50, "RB Smissaert" <bartsmissa....@blueyonder.co.uk>
wrote:
> All explained nicely here:http://www.cpearson.com/excel/vbe.aspx
>
> RBS
>
> "thread" <yaniv...@gmail.com> wrote in message
>
> news:c1c9d256-e0d2-47b6-8b7a-(E-Mail Removed)...
>
>
>
> > Hi all
> > does anyone have examples of vba code that adding vba code line?-הסתר טקסט מצוטט-
>
> -הראה טקסט מצוטט-

thank you very much