When MultiLine Txt Box Returns a square to the formated wordwrap cell

[Cory Not Available]

OK heres my problem.

I have a MultiLine TxtBox on the Form, and when I enter in the box and
press return rather then keep typeing it send a Box to the cell after I
entered the info.

For example

Text box __________________________
| this is a test {RETURN}|
| |
| |
| |
__________________________

The Sheet then returns the following to the cell:
this is a test []

Any information would help

 

[Dave Peterson]

Maybe you could clean it up before you update the cell:

Option Explicit
Private Sub CommandButton1_Click()
Dim myStr As String
myStr = Me.TextBox1.Value
myStr = Application.Substitute(myStr, vbNewLine, vbLf)
ActiveSheet.Range("a1").Value = myStr
End Sub

OK heres my problem.

I have a MultiLine TxtBox on the Form, and when I enter in the box and
press return rather then keep typeing it send a Box to the cell after I
entered the info.

For example

Text box __________________________
| this is a test {RETURN}|
| |
| |
| |
__________________________

The Sheet then returns the following to the cell:
this is a test []

Any information would help