Help with TEXTBOX control

[John Cosmas]

I am trying to find a TEXTBOX control which will show the actual cell content
of my worksheet cell. The FORM 2.0 TEXTBOX control which comes with VBA in
Excel flattens everything that I put into a cell, including a VBCRLF
character. I've tried using the CONTROLSOURCE and VALUE properties to try
and feed the information from my cell.

 

[Dave Peterson]

I bet you mean you're using vblf's in that cell (same as alt-enters).

Show the properties for that textbox.
Make sure that WrapText is true and multiline is true.

If you really meant vbcrlf, then I think you'll have to remove the cr portion
yourself (in code).

 

[John Cosmas]

Thanks, Dave. That did it. I will try to return the favor.