MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

is there any way to have a wrap around box and not keep running box?

  Asked By: Lydia    Date: Nov 13    Category: MS Office    Views: 601

The standard box for text doesn't allow me to put in a box that does
word wrap around. Is it possible to code some macro that does this?



2 Answers Found

Answer #1    Answered By: Iris Sanders     Answered On: Nov 13

Assuming you mean a standard  textbox in a userform, it can be pretty
much be set up any way you want it to, so some examples would be:

TextBox1.MultiLine = True
TextBox1.WordWrap = True
TextBox1.MaxLength = 360 'i.e. maximum number of characters
TextBox1.BackColor = RGB(255, 255, 255) 'background color
TextBox1.ForeColor = RGB(0, 0, 0) 'font color


If that's not what you mean, please clarify. I didn't understand
what you meant by "and not keep running  box" . . . ?

Answer #2    Answered By: Olga Allen     Answered On: Nov 13

It occurred to me after I sent that last, that you can go to the
properties window in VBE for the textbox and set the wordwrap value
to 'true' as the standard  setting in a userform. Note, however, that
I think you have to set the Multiline to TRUE before the wordwrap can
The only other version of a 'standard textbox' that I could think of
is an inputbox, and I don't know how to set that to do wordwrap, but
since it scrolls from right to left, I couldn't see how that would be
needed. I don't know for sure about that, though.