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!
|