VB.NET line break in header code

Thanks to Chip's help, I have the code to set up a header on my Excel
Worksheet:

CDRLWs.PageSetup.LeftHeader = "CDRL: " & ComboBox2.Text & " DID No.: N/A"

Yet, I was wondering if there was a way to put a line break in the middle.

I would like my left header to look like this (currently, it is on one line):

CDRL: A001
DID No.: N/A

Is there a way to set this up properly?

Thanks in Advance,
Elena

Elena,

Try something like

ActiveSheet.PageSetup.CenterHeader = "Line One" & Chr(10) & "Line
Two"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Elena" <[email protected]> wrote in message
news:[email protected]...
> Thanks to Chip's help, I have the code to set up a header on my
> Excel
> Worksheet:
>
> CDRLWs.PageSetup.LeftHeader = "CDRL: " & ComboBox2.Text & " DID
> No.: N/A"
>
> Yet, I was wondering if there was a way to put a line break in
> the middle.
>
> I would like my left header to look like this (currently, it
> is on one line):
>
> CDRL: A001
> DID No.: N/A
>
> Is there a way to set this up properly?
>
> Thanks in Advance,
> Elena

PERFECT!

"Chip Pearson" wrote:

> Elena,
>
> Try something like
>
> ActiveSheet.PageSetup.CenterHeader = "Line One" & Chr(10) & "Line
> Two"
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
> "Elena" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks to Chip's help, I have the code to set up a header on my
> > Excel
> > Worksheet:
> >
> > CDRLWs.PageSetup.LeftHeader = "CDRL: " & ComboBox2.Text & " DID
> > No.: N/A"
> >
> > Yet, I was wondering if there was a way to put a line break in
> > the middle.
> >
> > I would like my left header to look like this (currently, it
> > is on one line):
> >
> > CDRL: A001
> > DID No.: N/A
> >
> > Is there a way to set this up properly?
> >
> > Thanks in Advance,
> > Elena
>
>
>