| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Textbox multiline Vs format in worksheet
In Userform1 I have a textbox (multiline = True; Word wrap = False) where I
need to enter 3 or 4 lines of text (I've implemented a scrollbar to accomodate if the text is greater than the size of the box). As I copy the textbox content to my underlying sheet1 the Comments Column causes my row to quadruple in size. How can I have my sheet NOT look this way; meaning the text beyond the normal 1" of the column doesn't need to be visible.. How can I acheive this? TIA, Jim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform Textbox multiline Vs format in worksheet
For a Textbox with:
The quick brown fox The quick brown fox The quick brown fox You want the cell to look like The quick bro The quick bro The quick bro I don't believe you can achieve that. Wrap Text would wrap the text and if you turn that off, then you would not have multiple lines in the cell. -- Regards, Tom Ogilvy "Jim May" wrote in message news:Zrx4f.1130$mV4.774@dukeread02... In Userform1 I have a textbox (multiline = True; Word wrap = False) where I need to enter 3 or 4 lines of text (I've implemented a scrollbar to accomodate if the text is greater than the size of the box). As I copy the textbox content to my underlying sheet1 the Comments Column causes my row to quadruple in size. How can I have my sheet NOT look this way; meaning the text beyond the normal 1" of the column doesn't need to be visible.. How can I acheive this? TIA, Jim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform Textbox multiline Vs format in worksheet
Sorry for any misunderstnding, but
I want my Column Widths to be 11.43 For a Textbox with: The quick brown fox The quick brown fox The quick brown fox You want the cell (worksheet) to look like Row Q (col) R (col) 50 The quick bro Virginia Where cell Q50 contains The quick brown fox The quick brown fox The quick brown fox and R50 is Virginia (State Column). Thanks, Jim "Tom Ogilvy" wrote in message ... For a Textbox with: The quick brown fox The quick brown fox The quick brown fox You want the cell to look like The quick bro The quick bro The quick bro I don't believe you can achieve that. Wrap Text would wrap the text and if you turn that off, then you would not have multiple lines in the cell. -- Regards, Tom Ogilvy "Jim May" wrote in message news:Zrx4f.1130$mV4.774@dukeread02... In Userform1 I have a textbox (multiline = True; Word wrap = False) where I need to enter 3 or 4 lines of text (I've implemented a scrollbar to accomodate if the text is greater than the size of the box). As I copy the textbox content to my underlying sheet1 the Comments Column causes my row to quadruple in size. How can I have my sheet NOT look this way; meaning the text beyond the normal 1" of the column doesn't need to be visible.. How can I acheive this? TIA, Jim |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform Textbox multiline Vs format in worksheet
After you write your data:
Columns("Q:Q").wraptext = False Columns("Q:Q").ColumnWidth = 11.43 -- Regards, Tom Ogilvy "Jim May" wrote in message news:y%y4f.1134$mV4.672@dukeread02... Sorry for any misunderstnding, but I want my Column Widths to be 11.43 For a Textbox with: The quick brown fox The quick brown fox The quick brown fox You want the cell (worksheet) to look like Row Q (col) R (col) 50 The quick bro Virginia Where cell Q50 contains The quick brown fox The quick brown fox The quick brown fox and R50 is Virginia (State Column). Thanks, Jim "Tom Ogilvy" wrote in message ... For a Textbox with: The quick brown fox The quick brown fox The quick brown fox You want the cell to look like The quick bro The quick bro The quick bro I don't believe you can achieve that. Wrap Text would wrap the text and if you turn that off, then you would not have multiple lines in the cell. -- Regards, Tom Ogilvy "Jim May" wrote in message news:Zrx4f.1130$mV4.774@dukeread02... In Userform1 I have a textbox (multiline = True; Word wrap = False) where I need to enter 3 or 4 lines of text (I've implemented a scrollbar to accomodate if the text is greater than the size of the box). As I copy the textbox content to my underlying sheet1 the Comments Column causes my row to quadruple in size. How can I have my sheet NOT look this way; meaning the text beyond the normal 1" of the column doesn't need to be visible.. How can I acheive this? TIA, Jim |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform Textbox multiline Vs format in worksheet
That nailed it Tom,
Thanks, "Tom Ogilvy" wrote in message ... After you write your data: Columns("Q:Q").wraptext = False Columns("Q:Q").ColumnWidth = 11.43 -- Regards, Tom Ogilvy "Jim May" wrote in message news:y%y4f.1134$mV4.672@dukeread02... Sorry for any misunderstnding, but I want my Column Widths to be 11.43 For a Textbox with: The quick brown fox The quick brown fox The quick brown fox You want the cell (worksheet) to look like Row Q (col) R (col) 50 The quick bro Virginia Where cell Q50 contains The quick brown fox The quick brown fox The quick brown fox and R50 is Virginia (State Column). Thanks, Jim "Tom Ogilvy" wrote in message ... For a Textbox with: The quick brown fox The quick brown fox The quick brown fox You want the cell to look like The quick bro The quick bro The quick bro I don't believe you can achieve that. Wrap Text would wrap the text and if you turn that off, then you would not have multiple lines in the cell. -- Regards, Tom Ogilvy "Jim May" wrote in message news:Zrx4f.1130$mV4.774@dukeread02... In Userform1 I have a textbox (multiline = True; Word wrap = False) where I need to enter 3 or 4 lines of text (I've implemented a scrollbar to accomodate if the text is greater than the size of the box). As I copy the textbox content to my underlying sheet1 the Comments Column causes my row to quadruple in size. How can I have my sheet NOT look this way; meaning the text beyond the normal 1" of the column doesn't need to be visible.. How can I acheive this? TIA, Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Textbox and multiline text | Excel Worksheet Functions | |||
| transferring multiline text from userform to worksheet - line break problem | Excel Programming | |||
| UserForm; Textbox; Multiline; NonPrintable Characters | Excel Programming | |||
| Copying multiline textboxes from userform to worksheet cell | Excel Programming | |||
| Multiline textbox.. Can you have multiple font colors within? | Excel Programming | |||
Hybrid Mode
