Help with TEXTBOX control
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. |
Help with TEXTBOX control
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 |
Help with TEXTBOX control
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 |
All times are GMT +1. The time now is 01:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com