Changing all different font sizes by a value

[Puffin617]

Hi,

Say for instance I have a document with different font sizes. Is it possible to increase all different sizes by 3 point for example... i.e, all 10 pt becomes 13pt and all 26pt becomes 29pt?



Regards,
Barend

[Bird_FAT]

Copy the following VBA code and change the values needed - if you are doing multiple replaces in one go, then copy the code 'from' and 'to' points and paste after the 'to' point and change again. You can repeat the code as many times as needed in one piece of code. (see green notations in the CODE)

Sub Alter_Text_Size()
'
' Created by Bird_FAT 21/05/2009
'
    Selection.Find.ClearFormatting    '<------Repeat from here
        
    With Selection.Find
        .Text = "*"
        .Replacement.Text = ""
        .Forward = True
        .Wrap = wdFindContinue
        .Format = True
        .Font.Size = 11                    '<------ Change the Font size
        .MatchCase = False
        .MatchWholeWord = False
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
        .MatchWildcards = True
    End With
    While Selection.Find.Execute
    Selection.Font.Size = 14            '<------ Change the Font size
    Wend                                     '<------Repeat to here
                                           '<------Paste copied section here
End Sub

[Puffin617]

Hey,

Thanx for the help but my problem is still not solved...

I'm not "looking" for specific font sizes in my document but want to change ALL font sizes up by a specific amount...

I've written a form to ask the user for the size increase but how do I apply this to all font sizes?

Is there a way to move through the document and save the fontsize AT THE CURSOR to a variable?

I'm well clued up with Excel VBA but not Word...

Thanx

[Puffin617]

Hey,

Figured it out :

I removed the .Font.Size = 12 from the "find" command and replaced

Selection.Font.Size = 14
with
Selection.Font.Size = Selection.Font.Size + 14

where 14 is my value i get from my User form

Thanx

[Puffin617]

NEW PROBLEM :

The font replacement does not stay within my selected text. It runs past to the end of the document then starts again at the beginning and keeps on in an infinite loop...

Here is my Code so far :

Private Sub CommandButton1_Click()

        'Application.ScreenUpdating = False
        
        SizeIncrease = TextBox1.Value
        
        If SizeIncrease = "" Then
                End
        End If
        
        Selection.Find.ClearFormatting                  '<------Repeat from here

        With Selection.Find
                .Text = "*"
                .Replacement.Text = ""
                .Forward = True
                .Wrap = wdFindContinue
                .Format = True
                '.Font.Size = 12                                           '<------ Finding a font with size "12"
                .MatchCase = False
                .MatchWholeWord = False
                .MatchWildcards = False
                .MatchSoundsLike = False
                .MatchAllWordForms = False
                .MatchWildcards = True
        End With
    
        While Selection.Find.Execute
                If OptionButton1 = True Then
                        Selection.Font.Size = Selection.Font.Size + SizeIncrease            '<------ Change the Font size
                Else
                        If Selection.Font.Size - SizeIncrease >= 1 Then
                                Selection.Font.Size = Selection.Font.Size - SizeIncrease            '<------ Change the Font size
                        Else
                                Selection.Font.Size = 1            '<------ Change the Font size
                        End If
                End If
        Wend
        
        'Application.ScreenUpdating = False
        
        frmChangeFontSize.Hide
        
End Sub

Attached is the VBA form that I use...

Your help would be appreciated...

[Bird_FAT]

Try putting the While - Wend statement inside the If statement rather than around it

    If OptionButton1 = True Then
        While Selection.Find.Execute
                Selection.Font.Size = Selection.Font.Size + SizeIncrease
        Wend
    Else
        >ETC,ETC,ETC<

Does that fix the issue?