Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Setting font size in footer

  1. #1
    Join Date
    13th July 2003
    Posts
    82

    Setting font size in footer

    I am using a macro that asks for the date to put in a footer, as follows:

    datestring = InputBox("Enter date to be printed in footers." & Chr(13) & _
    "Leave blank if current date is to be used.", _
    "Set Up Footer Date")
    If Not datestring = "" Then
    Sheets("Pricing Summary").Select
    ActiveSheet.PageSetup.RightFooter = datestring
    End If

    How do I also specify the font (Arial) and font size (10) to use for this text?

    Thanks.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    28th January 2003
    Location
    India
    Posts
    1,038
    Here is the code:



    With Sheets("Pricing Summary").PageSetup
    .RightFooter = "&""Arial,Italic""&8Report Date:" & datestring
    end with

    Hope this will help you.

    Maqbool

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    5th October 2003
    Location
    Walsall, England
    Posts
    131
    Try using the macro recorder to generate the necessary code. I tried it and got the following (not using your example exactly):

    VB:
    With ActiveSheet.PageSetup 
        .LeftFooter = "&""Arial Black,Bold""&10hello" 
    End With 
    
    
    HTH
    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

  4. #4
    Join Date
    13th July 2003
    Posts
    82
    I finally figured it out, using:

    Sheets("Worksheet Name").Select
    ActiveSheet.PageSetup.RightFooter = "&""Arial""&12" & datestring

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Change Font Color In Print Footer
    By lezaheam in forum EXCEL HELP
    Replies: 3
    Last Post: June 10th, 2008, 01:48
  2. Replies: 1
    Last Post: June 26th, 2006, 11:05
  3. Replies: 14
    Last Post: June 5th, 2006, 08:11

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno