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.

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 wrote:

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

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

"Dave Peterson" wrote:

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 wrote:

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