Hi

I am using Excel 2000.
I have a userform with some textboxes on, quite a lot of text is goin
to be entered into them, so i would like the user to be able to chang
paragraph.

I have set the textbox EnterKeyBehaviour Property to True this allow
the user to press enter and instead of going onto the next text box, i
starts a new line.
However, here's the problem:
Whenever the enter key is pressed, when the data is stored back ont
the worksheet, or printed, a small empty box symbol is displayed a
enter.

_
Eg. when I change line l_l
I get a box at the end!

Does anyone know how I can stop this from happening, I do not want t
print or show this symbol, but I do want users to be able to chang
onto a new line.

Thanks a lot for any help
Jenni

--
jenni
-----------------------------------------------------------------------
jennie's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=26678