VBA-Remove paragraph marks in a textbox

  • Thread starter Thread starter Edward
  • Start date Start date
E

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?
 
Hi Edward

Not sure I understand why you cannot set Enter Key Behaviour to False in
Properties?
 
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.
 
Back
Top