Comments textbox within a userform

[MTBer]

I'm putting together a userform and the users have requested a textbox into which they can just add comments/notes. I set up a largeish text box but all the keyed text is just added as one long sentence, is it possible to write effectively short paragraphs and points into the the textbox and if so how do you pass them back to excel.

cheers,
Paul

 

[parry]

Hi Paul, right click the textbox and select properties. Amend these properties as follows:-

EnterKeyBehaviour = True
MultiLine = True
WordWrap = True

This will allow the user to press enter to get another line and word wrap the text. I cant remember the limits but you may be limited to 256 characters in the textbox even though a cell can actually hold more. To place a value into the cell create a command button and for the click event for the control have somehing like this substituting Commandbutton1 & TextBox1 to suit the names of your controls.

Private Sub CommandButton1_Click()
'Place textbox value into cell A1 on sheet1
Sheets("Sheet1").Range("A1").Value = Me.TextBox1.Value
End Sub

[/code]