ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VB.NET code for Header Font (https://www.excelbanter.com/excel-programming/355892-vbulletin-net-code-header-font.html)

Elena

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

Chip Pearson

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





All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com