Sorry forgot the vb code for the header!

  • Thread starter Thread starter SV
  • Start date Start date
S

SV

'Create Header and Footer
headerText = "Preliminary Sales Forecast for " & drugName & "
and " & indicationName & "-" & sht.Name
sht.PageSetup.CenterHeader = headerText

dateNum = Format(Date, "mmmm d, yyyy")
sht.PageSetup.RightHeader = dateNum

Could someone help me make this font size 12 and also bold??

Thanks!
SV
 
P. S. See Formatting codes for Headers and Footers in VBA help files. Open
the VB editor, click help, type the topic in the search box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Header 2
Help with Header 2
Can't insert a String Variable of Long Date into Page Header 3
Count the number of times the date is a Monday, Tuesday, etc 5
Date value in page header for a year ago (month and year only) 5
Update records using datagrids 1
Better support for dynamic content within headers and footers 1
conditional format for vb code on pivot output 2

Back
Top