View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Double Space in Text Box or Excel Cell

Maybe this:

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

With TextBox1
.Text = Replace(.Text, vbNewLine, vbNewLine & vbNewLine)
End With

End Sub

NickHK

"mpierson" wrote in message
...
I am creating a form and would like to use Excel. My hangup is that I

need
to be able to enter text double spaced without having to go back after

it's
entered and physically put in a return (such as in a text box). Is there

a
way to format for double spacing? Can't find it!