How to enable Grow Text Box To Fit in MS Publisher using VBA

Question

Hi MS Publisher VBA programmers :-)

What seems so simple is actually not documented. All I need to do is be able to insert text programmatically into a text box then have the text resize vertically expanding itself as I add more text.

This works fine if I do it manually by inserting TextBox and choosing the "Grow Text Box To Fit" option in the Text Fit drop-down in the Format tab of the TextBox.

This code doesn't work:

Sub myGrowToFit()
        Set myTextBox = ActiveDocument.Pages(1).Shapes.AddTextbox _
             (Orientation:=pbTextOrientationHorizontal, _
             Left:=0, Top:=0, _
             Width:=100, Height:=40)
        myTextBox.TextFrame.TextRange.text = "Line1" & vbLf & "Line2" & vbLf & "Line3" & vbLf & "Line4"
        myTextBox.TextFrame.AutoFitText = pbTextAutoFitGrowToFit
        MsgBox ("Press OK to Continue After You View The Result")
        myTextBox.Delete
End Sub

Any ideas? Thanks.

Tried it earlier in 2016 and still the same problem. Nothing happens when I run the code. it just displays the dialog box with no height adjustment. — Mickey D, Nov 09 '17 at 00:52

score 0 · Answer 1 · answered Sep 20 '21 at 18:09

2021 and I wasn't able to get this to work for Office 365 ProPlus Publisher.

However, easy workaround for me was to use the .Overflowing property (doc). I just shrink the text until the Overflow property is equal to 0 which indicates it's not overflowing.

 Dim titleTextbox As Shape
 Set titleTextbox = ActiveDocument.Pages.Item(1).Shapes("My Textbox Name")
 
 Dim initialTextSize As Integer
 initialTextSize = titleTextbox.textFrame.TextRange.Font.Size

 While (titleTextbox.textFrame.Overflowing < 0)
    initialTextSize = initialTextSize - 1
    titleTextbox.textFrame.TextRange.Font.Size = initialTextSize
 Wend

Conversely, if you want to grow the text then increase the size in the while loop instead of decreasing it. Then once it overflows, exit loop and decrease the size by one.

Also, I wasn't able to find documentation for pbTextAutoFitGrowToFit, so if you have it please share if you wouldn't mind.

This resource I found, https://learn.microsoft.com/en-us/office/vba/api/publisher.pbtextautofittype, only shows three, pbTextAutoFitBestFit, pbTextAutoFitNone, pbTextAutoFitShrinkOnOverflow.

Hopefully someone figures out how to set the AutoFitText property one day.

How to enable Grow Text Box To Fit in MS Publisher using VBA

1 Answers1