Replacing Non Printable Characters

  • Thread starter Thread starter SA3214
  • Start date Start date
S

SA3214

I have a userform in which comments are entered in a Multiline Textbox.
After transferring the contents of the textbox to a cell I find that it
contains a non printable character symbol at the end of each line.
How can I
a) prevent this from happening and
b) replace the existing non printable characters with Alt&Enter

Regards and TIA

Jim Burton
 
I have included a bit of code when saving the data
i.e. Replace(textbox, Chr(13), "")
and it seems to work ok

also used it to cycle through the existing cells to remove previous
occurrences

Regards to all
Jim Burton
 
thanks :) simple but work perfectly

Regards
Przemek

„SA3214 @Eclipse.co.uk>†pisze:
 
Back
Top