ps.

Replace was added in xl2k. You could use application.substitute if you're using
xl97.

"Corey ...." wrote:

I am using a form to enter data into a cell in another sheet.
The form Textbox has mulitline enabled. It works fine, however:
When there is more than 1 line of text needed, the user hits the Enter Key
on the keyboard, to naviaget to the next line.
All looks well on the form, but when the data is produced on the sheet, each
Enter Key used places a small square Box(charater) in the cell with
multiline enabled.

The lines of text do move to the next line as required, but they have the
small square box as the last charater.
Is there any way to not display the small square box character in the cell?
Like a lkine of code that removes the character, but still maintaining the
correct multiline format?

Corey....

--

Dave Peterson