View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Forms - return keyed leaves square

First, make sure Wrap Text is set for the Cell. If that doesn't correct it,
then

Remove any ControlSource property setting. Then

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

With Worksheets("Sheet1")
.Range("B9").Value = Replace(TextBox1.Text, Chr(13), "")
End With
End Sub

--
Regards,
Tom Ogilvy

"themillman" wrote in message
...
On my forms when you use return key in field it displays a square symbol

on
worksheet and also prints - how do I hide this?

tia