+ Reply to Thread
Results 1 to 12 of 12

How to Select specific height font

  1. #1
    Forum Contributor
    Join Date
    08-27-2016
    Location
    INDIA
    MS-Off Ver
    2003,2007,2010
    Posts
    134

    Question How to Select specific height font

    Helo all..

    In my document i need to change specific font height. for example i want to select 13.5 height text, after selected i want to change/modify 13.5 to 10 height. please suggest solution.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: How to Select specific height font

    Worksheet selection change even the set font.size to the the values you want and after that reset it
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: How to Select specific height font

    Keebellah: Your reply has nothing to do with the OP's question.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: How to Select specific height font

    structo: You can do that with a simple Find/Replace, without even selecting anything. Or you could employ a simple macro like:
    Please Login or Register  to view this content.
    Note that the above code doesn't check the current size. You could assign such a macro to a keyboard shortcut.

    Otherwise, if you really want something to happen on the basis of making a selection, you'd need to implement a WindowSelectionChange event, for which see: https://wordmvp.com/FAQs/MacrosVBA/AppClassEvents.htm

    For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: How to Select specific height font

    @Mmacropod:
    Quote Originally Posted by macropod View Post
    Keebellah: Your reply has nothing to do with the OP's question.
    Enlighten me, please, your answer (code0 odes just what I mentioned/answered

  6. #6
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: How to Select specific height font

    What do you suppose "Worksheet selection change" has to do with a Word question???

  7. #7
    Forum Contributor
    Join Date
    08-27-2016
    Location
    INDIA
    MS-Off Ver
    2003,2007,2010
    Posts
    134

    Re: How to Select specific height font

    Hi,
    Thank you for reply..
    as per your code nothing happening (Nothing selected) in my file.

    my question is simple. i have 200 pages word file. it contains several type of font sizes like 13.5, 14, 16 etc...

    my requirement is select all 13.5 size font and after that this font should be changed to 10 size font ( 13.5 to 10).

    so how i find all 13.5 sized font and how to change as 10 by single attempt.

  8. #8
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: How to Select specific height font

    Quote Originally Posted by structo View Post
    my requirement is select all 13.5 size font and after that this font should be changed to 10 size font ( 13.5 to 10).
    And as I previously said:
    Quote Originally Posted by macropod View Post
    You can do that with a simple Find/Replace, without even selecting anything.
    You don't need a macro for this. Surely you know how to use Find/Replace???

  9. #9
    Forum Contributor
    Join Date
    08-27-2016
    Location
    INDIA
    MS-Off Ver
    2003,2007,2010
    Posts
    134

    Re: How to Select specific height font

    Yes I want to know how to find and select all 13.5 sized font?

  10. #10
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: How to Select specific height font

    As I have said before, you don't need to select anything. Just use a Find/Replace, where:
    Find font size = 13.5
    Replace font size = 10
    You don't need to specify any Find or Replace text or have anything selected.

  11. #11
    Forum Contributor
    Join Date
    08-27-2016
    Location
    INDIA
    MS-Off Ver
    2003,2007,2010
    Posts
    134

    Re: How to Select specific height font

    ok Thank you macropod.

  12. #12
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: How to Select specific height font

    @macropod: true,sorry, but If the questionnaires is in the excel VBA macros section and it’s late, welk, i stand corrected

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Font style & Font size not displaying when I select in the word doc
    By raju.r.083 in forum Word Formatting & General
    Replies: 13
    Last Post: 10-24-2022, 08:12 PM
  2. [SOLVED] Font and Row Height with multi with or if statements
    By sas2007 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2012, 03:23 PM
  3. [SOLVED] How do I stretch the height of a font in Excel 2003
    By HyPipeRep in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  4. [SOLVED] How do I stretch the height of a font in Excel 2003
    By HyPipeRep in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  5. [SOLVED] How do I stretch the height of a font in Excel 2003
    By HyPipeRep in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. [SOLVED] How do I stretch the height of a font in Excel 2003
    By HyPipeRep in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. How do I stretch the height of a font in Excel 2003
    By HyPipeRep in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

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