ExcelBanter - LINE INSERTION IN TEXT !!!

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - LINE INSERTION IN TEXT !!! (https://www.excelbanter.com/excel-programming/428269-line-insertion-text.html)

Jay Dean

LINE INSERTION IN TEXT !!!

Hello -

I have Textbox7.value="ABC:" & "" & "EFG:" & "" & "HIJ:"

How do I make Textbox7 display the string as --

ABC:
EFG:
HIJ:
instead of ABC: EFG: HIJ:? That is, how do I insert a (return key/a
line) after each entry Textbox7?

Any help would be appreciated!

Thanks
Jay

*** Sent via Developersdex http://www.developersdex.com ***

AltaEgo

LINE INSERTION IN TEXT !!!

vbcrlf (carriage return, line feed).

="ABC:" & vbcrlf & "EFG:" & vbcrlf & "HIJ:"

--
Steve

"jay dean" wrote in message
...
Hello -

I have Textbox7.value="ABC:" & "" & "EFG:" & "" & "HIJ:"

How do I make Textbox7 display the string as --

ABC:
EFG:
HIJ:
instead of ABC: EFG: HIJ:? That is, how do I insert a (return key/a
line) after each entry Textbox7?

Any help would be appreciated!

Thanks
Jay

*** Sent via Developersdex http://www.developersdex.com ***

Jay Dean

LINE INSERTION IN TEXT !!!

Thank you, AltaEgo !

Jay

*** Sent via Developersdex http://www.developersdex.com ***

AltaEgo

LINE INSERTION IN TEXT !!!

You are most welcome.

--
Steve

"jay dean" wrote in message
...
Thank you, AltaEgo !

Jay

*** Sent via Developersdex http://www.developersdex.com ***

All times are GMT +1. The time now is 01:57 AM.