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

  • Thread starter Thread starter Cory Not Available
  • Start date Start date
C

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
 
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
 
Back
Top