Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have implemented a textbox on a Userform and it works fine. My only
issue with it is, if the amount of text I enter into the box becomes larger than it can show, it moves up with no scrollbars to the right. Is there a property setting I can manipulate or even a subroutine I can add to make the right hand side of the textbox automatically show a scrollbar when the text entered starts moving up? Thanks Jay *** Sent via Developersdex http://www.developersdex.com *** |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Have you set ScrollBars fmScrollBarsNone to fmScrollBarsVertical and set MultiLine in the textboxes' properties box? jay dean;323335 Wrote: I have implemented a textbox on a Userform and it works fine. My only issue with it is, if the amount of text I enter into the box becomes larger than it can show, it moves up with no scrollbars to the right. Is there a property setting I can manipulate or even a subroutine I can add to make the right hand side of the textbox automatically show a scrollbar when the text entered starts moving up? Thanks Jay *** Sent via Developersdex 'Developersdex.com - The Web Developers Index and Directory' (http://www.developersdex.com) *** -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90346 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank you, Simon! ...That solved it. I knew I hadn't setup some
property right. Thanks again! Jay *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Default font for pasted text in text boxes - Excel 2007 | Excel Discussion (Misc queries) | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
Setting an array of text boxes equal to individual form text boxes | Excel Programming | |||
How do I link Text Boxes to Cells, not Cells to Text Boxes? | Excel Worksheet Functions | |||
In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions |