| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB.NET line break in header code
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB.NET line break in header code
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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| Inserting header @ page break | Excel Discussion (Misc queries) | |||
| 1st line is the header, how do I have it print as the first line | Excel Programming | |||
| 1st line is the header, how do I have it print as the first line | Excel Programming | |||
Linear Mode
