Simple VBA Header, Changing Font and Size of Text

[TheLaughingMan]

Howdy,
I have been at this for days and just can not figure it out. I don't ever use VBA so i'm crash coursing it pretty hard.
I was able to make the header reference two cells, and even put a line break in between the two.
My next step is to make the first cell Calibri, Bold and 22 font. And the second referenced cell to show up as Calibri, bold, 12 font.

So basically like this:
12345
Plant 2

I say basically because the size selection is off here i think, but generally this is what i am looking to accomplish.
Here is the code i am using thus far:

Please Login or Register  to view this content.

This code calls the cells properly, but i just can't get the formatting to stick.
Calculations!B36 needs to be Calibri, Bold, and 22 point font.
"Plant " and Calculations!B37 need to be Calibri, Bold and 12 point font.
Oh and it all needs to be right justified, but that is automatic being in the right header pane.

Any help would be appreciated.
Thanks in advance :D

[Mumps1]

Here is an example of how you can format a cell. I hope this helps.

Please Login or Register  to view this content.

[TheLaughingMan]

If i format the cell, will the format carry over to the header where it is being referenced?

[Mumps1]

Sorry but to be honest with you, I'm not sure. Perhaps you could try it out and post back the result.

[TheLaughingMan]

Sorry but to be honest with you, I'm not sure. Perhaps you could try it out and post back the result.

No worries, i had to get back to my office. Changing the format of the original cell it is calling does not affect the formatting of the header.

[Mumps1]

Thanks for posting back. Sorry I couldn't be of more help.

[JapanDave]

This should do what you are looking for,

Please Login or Register  to view this content.

[TheLaughingMan]

BOOM!
That is what i needed