Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default VB.NET code for Header Font

I need my header to be in bold.

This is the code I have so far:

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

(This is my last question of the day, I promise).

Thanks!!
Elena
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default VB.NET code for Header Font

Try


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

The &B makes it bold.

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



"Elena" wrote in message
...
I need my header to be in bold.

This is the code I have so far:

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

(This is my last question of the day, I promise).

Thanks!!
Elena



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
header font colour Michelle Excel Discussion (Misc queries) 0 June 4th 08 04:35 PM
Omit header from first page without embedding header in code ibvalentine Excel Worksheet Functions 6 August 28th 07 05:10 AM
Colour of font in header/footer Gilbert De Ceulaer New Users to Excel 1 March 19th 06 02:04 PM
Header Font size Mike Fogleman Excel Programming 3 June 22nd 05 01:12 AM
Header Font Color neenmarie Excel Programming 3 July 6th 04 01:11 PM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"