See the LineCount property in Help

Private Sub UserForm_Click()
MsgBox UserForm1.TextBox1.LineCount
End Sub

--
Bob Kilmer


"Dan Butler" wrote in message
...
I asked earlier for a way to help decrement font size in order to fill
it
in a textbox that has a set width and height. I think i may have
found a way of doing this if it is possible to determine line counts in
a textbox with multiline and wordwrap set to true.

I want my text box to have a maximum of 3 lines. If the text length
wraps more than 3 lines to decremnet the font size untill goal is
met. I figured tis could be done easy if i can count the amount of
wordwraps performed or the amount of lines used with the
multiline. I haven't founf any docuentaion to help this however. Any
ideas?

..Autosize is not an option as the text box must remian a set
dimmension. scrollbars are also unusaable due to the fact that all
the text must be visible in the textbox upon printing. Thanks
everyone for your help

Dan Butler


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I'm sorry, It's not a userform textbox or an embedded textbox, just a
textbox created from the drawing table onto a worksheet. I would use the
embedded box but i cannot center both horizontally and vertically. Any way
of getting linecount or similar working?
I need to keep the word wrap to only two wraps, (3 lines). Thanks

"Bob Kilmer" wrote in message
...
See the LineCount property in Help

Private Sub UserForm_Click()
MsgBox UserForm1.TextBox1.LineCount
End Sub

--
Bob Kilmer


"Dan Butler" wrote in message
...
I asked earlier for a way to help decrement font size in order to fill
it
in a textbox that has a set width and height. I think i may have
found a way of doing this if it is possible to determine line counts in
a textbox with multiline and wordwrap set to true.

I want my text box to have a maximum of 3 lines. If the text length
wraps more than 3 lines to decremnet the font size untill goal is
met. I figured tis could be done easy if i can count the amount of
wordwraps performed or the amount of lines used with the
multiline. I haven't founf any docuentaion to help this however. Any
ideas?

..Autosize is not an option as the text box must remian a set
dimmension. scrollbars are also unusaable due to the fact that all
the text must be visible in the textbox upon printing. Thanks
everyone for your help

Dan Butler


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!