Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Text Boxes
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Text Boxes
Since you do not say what aspect does not work as expected, I guess you may
need to set the textbox property Multiline = True ? -- Regards, Nigel "amit" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Text Boxes
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 "Nigel" wrote: Since you do not say what aspect does not work as expected, I guess you may need to set the textbox property Multiline = True ? -- Regards, Nigel "amit" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Text Boxes
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 "amit" wrote in message ... 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 "Nigel" wrote: Since you do not say what aspect does not work as expected, I guess you may need to set the textbox property Multiline = True ? -- Regards, Nigel "amit" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default font for pasted text in text boxes - Excel 2007 | Excel Discussion (Misc queries) | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
How to Import Visio Text Boxes into Excel as Text | Excel Discussion (Misc queries) | |||
How do I link Text Boxes to Cells, not Cells to Text Boxes? | Excel Worksheet Functions | |||
In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions |