Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box on a form
I have a text box on a form. Users will enter text that
may be longer then the text box. However, the text box is tall enough to handle two or three. In the event that the user enters enough info to more than fill the visual part of the text box, I would like for there to be a scroll bar to scroll through the multiple lines of text. I feel that I have done this before. Maybe I used a list box or combo box. I can't remember, and can't seem to find the property for either of these three that would enable me to get the desired result. I'm desperate for help, as I'm very close to completing this project. Thanks in advance!!! Eric W. Madison, WI |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box on a form
Hi Eric,
You need to set three properties of the TexBox control to make this work: 1) MultiLine: True 2) ScrollBars: 2 - fmScrollBarsVertical 3) WordWrap: True -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Eric W." wrote in message ... I have a text box on a form. Users will enter text that may be longer then the text box. However, the text box is tall enough to handle two or three. In the event that the user enters enough info to more than fill the visual part of the text box, I would like for there to be a scroll bar to scroll through the multiple lines of text. I feel that I have done this before. Maybe I used a list box or combo box. I can't remember, and can't seem to find the property for either of these three that would enable me to get the desired result. I'm desperate for help, as I'm very close to completing this project. Thanks in advance!!! Eric W. Madison, WI |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box on a form
Hi Eric:
Set the ScrollBars property of the TextBox to 2 and the WordWrap property to True. Regards, Vasant. "Eric W." wrote in message ... I have a text box on a form. Users will enter text that may be longer then the text box. However, the text box is tall enough to handle two or three. In the event that the user enters enough info to more than fill the visual part of the text box, I would like for there to be a scroll bar to scroll through the multiple lines of text. I feel that I have done this before. Maybe I used a list box or combo box. I can't remember, and can't seem to find the property for either of these three that would enable me to get the desired result. I'm desperate for help, as I'm very close to completing this project. Thanks in advance!!! Eric W. Madison, WI |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text in a PDF form | Excel Discussion (Misc queries) | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
Inserting text into a PDF form? | Excel Discussion (Misc queries) | |||
DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM | New Users to Excel |