Need somebody's help on this hum-dinger:

SITUATION: I have a TextBox in a UserForm. I've set the MultiLine switch to "True" on the properties for the TextBox. In this way, user can make simple lists using [Ctrl Tab] and [Ctrl Enter]. The TextBox is linked to a cell (ControlSource).

PROBLEM: The specified linked cell (ControlSource) shows the text okay on the worksheet, and even shows the simple lists. However, it also shows the "pipe" symbol ("|") for each of the hard tabs and [Returns]. If referencing this linked cell (i.e. "=A1") the symbols come through as little (Wingding?) squares ... equally annoying.

SOLUTION SOUGHT: To have the formatted contents of the TextBox duplicated EXACTLY in the linked cell and the referenced cell, replete with these simple lists - that is, remove the pipes. (What I really need is a property box on the worksheet cell.)

If you have the solution (though I'm really not sure there is one) and you're in New York city, I'll buy you dinner -- seriously; I've got a large project that's hanging over the cliff on this!

Thanks!

Mark