Forum Discussion
Using a checkbox to toggle the Char(10) command inside a textbox now working
Select J3.
Set the number format to General instead of Text.
Press F2 to edit J3, then press Enter.
Fill down from J3 as far as you want.
Select J3.
Set the number format to General instead of Text.
Press F2 to edit J3, then press Enter.
Fill down from J3 as far as you want.
In addition to what Hans mentioned above (i.e. "=CHR(10)" is current formatted as TEXT and must be converted to general so the formula actual outputs the line break character),
I can't speak to the activeX control but note that in a cell if you have wrap text off it will ignore the line break and with wrap text on it will respect the line break but will also wrap text as needed. For example in this image:
The lower blue box has wrap text on and both of the last 2 lines show how that chr(10) causes a line break BUT you can see that the 1st line also wraps text.
And then in the upper blue box the wrap text is off and you can see how it just spills to the right and does NOT respect the chr(10) line break.
Wonderful! Thank you so much fr the help!! : )
Oh! Okay. Yes! That worked!! You fixed it!!!! YAYYYY!!!! Thank you so much!!!!
