VBA Change Header Font Size and Text

[Dmichaud61]

Greetings
Can the below VBA string be modified to add the word "Date:" before the actual date, and change the font to Ariel 12 point bold? I'm using MS Office Professional 2013 and Windows 10 Enterprise.

RightHeader = Format(Date, "dd-mmm-yy") & Chr(10) & "Page: &P of:&P"

As an example, the string currently produces the following results:

17-Sep-19
Page: 1 of 10

I want the sting to produce:

Date: 17-Sep-19
Page: 1 of 10

Thanks in advance!

 

[Peter_SSs]

Try

RightHeader = "&""Arial,Bold""&12Date: " & Format(Date, "dd-mmm-yy") & Chr(10) & "Page: &P of:&P"

 

[Dmichaud61]

Peter - much appreciated. Your edits worked perfectly! I've been trying for several hours without any success.

 

[Peter_SSs]

Peter - much appreciated. Your edits worked perfectly! I've been trying for several hours without any success.

You're very welcome. Thank for the confirmation.