Format Text Boxes

[amit]

Hi - i've got some text boxes in my userform and the word wrap in the
properties section doesnt seem to work the way Wrap Text works in an excel
cell?

 

[Nigel]

Since you do not say what aspect does not work as expected, I guess you may
need to set the textbox property Multiline = True ?

 

[amit]

thx Nigel - the horizontal centering is what i'm looking for....so if i hav a
text box that can take more than one line then i need that one line to be in
the centre of the box rather than at teh top

 

[Rick Rothstein \(MVP - VB\)]

Can you clarify this a little bit? You said "horizontal centering", but your
mention text being in the center rather than at the top, which would be
vertical centering... which did you want? Also, you said if there is more
than one line "then I need that one line to be in...", but if there is more
than one line, which "one line" were you talking about? Are you asking to
have the text, as a paragraph, be centered both horizontally and vertically
in the TextBox? If so, how do you know at what width to make the text word
wrap? Or are you willing to have it be centered if narrower than the with of
the TextBox, but go from left border to right border if long enough to do
so? By the way, are users going to be able to type into this TextBox? If
not, why aren't you using Labels?

Rick