Results 1 to 2 of 2

change RightHeader text Font Size

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    3

    change RightHeader text Font Size

    Sir I try but not Change Right Header Text Font size change


    This Original Formula

    Sub Invoice_Button4_Click()
    
        Dim n As Long
        n = Application.InputBox("Number of printed copies.?", "Printed Copies", 1, Type:=1)
        If n <= 0 Then Exit Sub ' User canceled
        With Sheets("402 FORM").PageSetup
            .RightHeader = "Original"
            Sheets("402 FORM").PrintOut
            If n > 1 Then
                .RightHeader = "Duplicate"
                Sheets("402 FORM").PrintOut
            End If
            If n > 2 Then
                .RightHeader = "Triplicate"
                Sheets("402 FORM").PrintOut
            End If
        End With
    End Sub
    
    I change this formula
    
    Sub Invoice_Button4_Click()
    
        Dim n As Long
        n = Application.InputBox("Number of printed copies.?", "Printed Copies", 1, Type:=1)
        If n <= 0 Then Exit Sub ' User canceled
        With Sheets("402 FORM").PageSetup
            .RightHeader = "Original"
            .Font = Arial
            .Font size = 15
            .Font Color = Bold
            Sheets("402 FORM").PrintOut
            If n > 1 Then
                .RightHeader = "Duplicate"
                .Font = Arial
            .Font size = 15
            .Font Color = Bold
                Sheets("402 FORM").PrintOut
            End If
            If n > 2 Then
                .RightHeader = "Triplicate"
                .Font = Arial
            .Font size = 15
            .Font Color = Bold
                Sheets("402 FORM").PrintOut
            End If
        End With
    End Sub
    Admin Note: Please use code tags as per rule 3.
    Last edited by arlu1201; 10-12-2013 at 06:24 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to using comma style without change font & font size
    By rameshtupe in forum Excel General
    Replies: 1
    Last Post: 07-11-2013, 01:19 PM
  2. [SOLVED] Change default font and font size on COMMENTS in cells
    By Thistledown in forum Excel General
    Replies: 4
    Last Post: 11-23-2012, 09:26 AM
  3. How to change the font/font size in a combo box
    By brendas in forum Excel General
    Replies: 2
    Last Post: 11-07-2005, 04:00 PM
  4. font is 10 pt:how do i change the font size in a combo box?
    By nkruppa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2005, 05:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1