Textbox question

[RobbertH]

I have a textbox on an userform that will enable the user to write some comments on date entered in the userform. I set the size of the textbox so that it will match other control sizes in the form. However, the user might have to enter more text than would fit in the user form.
How do I set the textbox so that
1. the width will remain as preset
2. the height will increase when enter is pressed
3. All text remains visible at all times

Hope this is possible. I get it to work separately but not together.

Thanks for any help!

 

[RobbertH]

How would you go about adding a carriage return to existing characters?

 

[Norie]

Something like this perhaps.

Change names as needed and check the Mod calculation, Mod in VBA slightly different from it's worksheet counterpart.

Private Sub TextBox1_Change()

   If (Len(TextBox1.Value) Mod 39) = 0 Then
      TextBox1.Value =TextBox1.Value& vbCrLf
   End If
End Sub

 

[sykes]

Robert
I'm a little confused. I believe that I've given you the solution you asked for, and on my machine it works perfectly.
You can set the text box width to anything you like, on the userform, then when you run the userform up, and type into the textbox, as soon as the full width is reached, a new line starts. The textbox doesn't change width at all - just as you asked.
When the enter key is pressed a new line is started in the textbox, and the height of the box is increased by (about) the height of your font - which is also what you asked for!

I must be misunderstanding something here???????????????