vba text into textbox doesn't fit with it width and height

Iban Arriola Published at Dev

Iban Arriola

I am creating a text box using vba in powerpoint. For that I am using the following code:

Set survey = cSlide.Shapes.AddTextbox(msoTextOrientationHorizontal, 20, 40, 400, 20)
    survey.TextFrame.TextRange.text = Me.QuestionBox.text


        survey.TextFrame.TextRange.font.SIZE = sh.GroupItems(1).TextFrame.TextRange.font.SIZE
        survey.TextFrame.TextRange.font.name = sh.GroupItems(1).TextFrame.TextRange.font.name
        survey.width = sh.GroupItems(1).width
        survey.height = sh.GroupItems(1).height
        survey.top = sh.GroupItems(1).top
        survey.left = sh.GroupItems(1).left

As you can notice I am using the size of another shape to make it the same size as it. This is how the shape that I am using (above) and I created (below) looks:

enter image description here

I want it to appear in 2 lines instead of one. You can see that the width and height is correct but instead of going to the second line when it reach to the border of the shape it continues. If you just modify manually the shape below and give a bit more or less width it automatically put the second word in the second line but I cannot make it happen when I do it with vba. Is there something I can use to make it happen automatically?

David Zemens

When you add new shape to the slide, your shape default settings may be preventing wordwrap.

Please try:

survey.TextFrame.WordWrap = msoTrue

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-7

Comments

0 comments

From Dev

Related Related

Article

vba text into textbox doesn't fit with it width and height

vba text into textbox doesn't fit with it width and height

Text doesn't fit in UIButton titleLabel height for a specific font

text area width and height doesn't change in table cell

Javascript to return content/string which doesn't fit in given width and height of UIWebView

Div with percentage height doesn't fit in

ScrollView doesn't fit width of parent

Resizing a textbox to fit text

Text in UItextview doesn't fit iPhone screen

Keeping a div at full height when it doesn't fit in viewport

Ionic popover: Popover height doesn't fit to content

Android Lollipop view height doesn't fit screen

Show image with its maximum width only if it doesn't fit the div

Site with a width of 1044px doesn't fit on an iPad

Text Box Height & Width

width and height doesn't seem to work on :before pseudo-element

Imagick compositeImage doesn't apply original width and height but smaller

RelativeLayout width and height fill_parent doesn't work

why doesn't height: 100% and width: 100% work?

Why doesn't font-size equal width and height in CSS?

getBoundingClientRect() doesn't return height and width of SVG rect

width and height doesn't seem to work on :before pseudo-element

why doesn't height: 100% and width: 100% work?

Why a button with an image doesn't respect width and height settings

Imagick compositeImage doesn't apply original width and height but smaller

Webpage that doesn't overflow and has a 100% Height/Width

Fit text perfectly inside a div (height and width) without affecting the size of the div

How can I auto shrink text to fit div width and height using javascript?

Fixed Width Columns in Textbox VBA

Resizing the height of UILabel to fit text

Make button width fit to the text