Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi All, I have a text box on my user form where users input "Description" about them. Rite now what is happening is, If a user inpus a data in that field the input is like: abcdefg higklafj aldkfjadfkl alkfjaldfkj aldfjaaldkfja ldsfjladfjfj I want it to be like: aldkfjdfa asdlfjaldksfj akldfjajf aldkfj alfkjjllfj aldkfjalfj adlffj adfljadfj aldfjdfk asdlfjladlfj. How can I design a text box such that it displays the text in this format? Thanks in Advance. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Set the TextBox's MultiLine and WordWrap properties to True. You may also want to set the ScrollBars property to 2 (vertical scroll bars) if your users are fond of entering a lot of text... -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113133 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display contents of a cell in a user form text box -- Excel 2003 VBA | Excel Discussion (Misc queries) | |||
how to use text boxes as an array in an EXCEL user form | Excel Programming | |||
User Form Text Box - auto delete prompt text | Excel Programming | |||
User Form texbox insert text in cell - excel 2003 | Excel Programming | |||
Text on User form | Excel Programming |