![]() |
MultiLine/WordWrap usage
I have a solution in excel where I am displaying statements from a module
(one statement at a time, selected from a listbox) in a textbox. I want the textbox to display the lines exactly as they are in the module. This is of particular importance when a statement spans multiple lines in the module, in which case the line-continuation character (_) ends all but the last line. In that case, if the lines has more characters than the textbox will display on a single line (and they usually do when they span multilines), I want the horizontal scroll bar to appear and the line clipped, while linebreaks following the line-continuation characters are displayed on a new line. Is there any way I can combine the settings of the ScrollBars, MultiLine, WordWrap, etc. properties in order to get all that accomplished? Thank you. |
MultiLine/WordWrap usage
As I read your post,
you do want your textbox to be multiline you don't want it to wrap and you want scrolbars (presumably both) Maybe I'm missing some obvious problem here. JonWayn wrote: I have a solution in excel where I am displaying statements from a module (one statement at a time, selected from a listbox) in a textbox. I want the textbox to display the lines exactly as they are in the module. This is of particular importance when a statement spans multiple lines in the module, in which case the line-continuation character (_) ends all but the last line. In that case, if the lines has more characters than the textbox will display on a single line (and they usually do when they span multilines), I want the horizontal scroll bar to appear and the line clipped, while linebreaks following the line-continuation characters are displayed on a new line. Is there any way I can combine the settings of the ScrollBars, MultiLine, WordWrap, etc. properties in order to get all that accomplished? Thank you. -- Steve Garman |
MultiLine/WordWrap usage
I figured it out, half way into this response. What I did, I had been doing
all along: I had Wrap = false, MultiLine=true, scrollbars=Horizontal. However, the scroolbar did not show until now that I hit the End key with the focus on the textbox. Having the focus on the textbox alone didnt display the scrollbar - the End key made it happen. Thank you for your response anyway. "Steve Garman" wrote in message ... As I read your post, you do want your textbox to be multiline you don't want it to wrap and you want scrolbars (presumably both) Maybe I'm missing some obvious problem here. JonWayn wrote: I have a solution in excel where I am displaying statements from a module (one statement at a time, selected from a listbox) in a textbox. I want the textbox to display the lines exactly as they are in the module. This is of particular importance when a statement spans multiple lines in the module, in which case the line-continuation character (_) ends all but the last line. In that case, if the lines has more characters than the textbox will display on a single line (and they usually do when they span multilines), I want the horizontal scroll bar to appear and the line clipped, while linebreaks following the line-continuation characters are displayed on a new line. Is there any way I can combine the settings of the ScrollBars, MultiLine, WordWrap, etc. properties in order to get all that accomplished? Thank you. -- Steve Garman |
All times are GMT +1. The time now is 03:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com