missing chars in a comment box
sStr = Replace(Textbox1.Text,chr(10),"")
and put sStr into your comment
Assumes xl2000 or later. Post back if you or your users are using xl97.
--
Regards,
Tom Ogilvy
"Roland" wrote in message
...
I have a VBA program where the user can input text in a userform textbox.
This text is copied to the commentbox using 'addcomment(textcomment.text)'
..
It works fine when no <enter button is used in the comment text. In the
latter case, a tine square box is displayed (for the linefeed/cr char?)
between the lines were it was pushed.
How can I avoid this square box?
thanks
|