Word wrap in Group Box (Form Control)

[Jeff G.]

Good afternoon,

I am creating a test on Excel using Group Boxes and Option Buttons. I'm trying to keep all columns the same size, but some of the questions are scenario based and can be lengthy. This initially causes the text to exceed past the group box causing me to stretch the box wider (I'm trying to avoid that and keep the boxes the same size to fit on one page). Is there a way to word wrap the text in a Group Box (Form Control)? *screenshot below*

-JeffWord Wrap.PNG

[BMV]

activesheet.shapes(1).drawingobject.text="12345" & vbcrlf & "67890"

[Jeff G.]

Where should this go?

[BMV]

it's VBA code and must be the part of a subroutine or a function. Also it could be run in immediate window of VB editor.