View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_21_] Stuart[_21_] is offline
external usenet poster
 
Posts: 154
Default Strange Character

I have a large TextBox in a Form, which has MultiLine set to True, and
WordWrap enabled.

When I copy the contents of this TextBox to a range in a sheet (where the
range consists of merged cells, and where Wraptext is enabled), I get
strange 'box-shaped'
characters appearing, which seem to represent where a carriage-return (enter
key) was used in the original Textbox.

Can I avoid this in some way (but still allow use of enter key in the
textbox) or, having copied the contents into the sheet range, can I then
remove them with code, please?

Regards.