VBA-Remove paragraph marks in a textbox

[Edward]

Hi everyone,
I have a userform with a big textbox that users can paste any text , and I
have some procedures to insert the text in a specific location in PP. The
source for the text that people paste in the textbox has many extra return
and softreturn character , I wonder is there a way to remove those extra
characters with VBA directly in the text box?
It should be easy to load the entire text in the textbox into an array or
even a string variable , scan the array and remove the return character and
finally and populate the text box on the userform with clean text, but I Was
wondering if we can do this directly in the textbox without using an
additional array or a string variable?

 

[John Wilson]

Hi Edward

Not sure I understand why you cannot set Enter Key Behaviour to False in
Properties?

 

[John Wilson]

Sorry I missed PASTE text!

 

[John Wilson]

Something like this maybe?

Private Sub TextBox1_Change()
Me.TextBox1 = Replace(Me.TextBox1.Text, vbCrLf, " ")
End Sub
--
john ATSIGN PPTAlchemy.co.uk

Free PPT Hints, Tips and Tutorials
http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html

 

[Edward]

Thanks guys .Not a specifc reason just curiosity to see if I can work
directly on a textbox control in a userform instead of using a variable. I
don't think in this case there will be a speed isuuse because users just
paste a large text once and instead of change event maybe I can use exit
event for the text box this way it will execute only once.