Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lots of text in text box problem
I have a text box in a user form that has 7 page document pasted inside
I have a vertical scroll bar selected in properties. When the Userform is opened, (1) the scroll bar is not visbile, and (2 when the user clicks into the text box, the box jumps down to near th end of the document and places the cursor there. I need: (1) the scroll bar to be visable when the form opens, and (2) want to placde the blinkinc cursor in front of the very first characte in the text box. Thanks in advance, Jason Sweene -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
lots of text in text box problem
-----Original Message----- I have a text box in a user form that has 7 page document pasted inside. I have a vertical scroll bar selected in properties. When the Userform is opened, (1) the scroll bar is not visbile, and (2) when the user clicks into the text box, the box jumps down to near the end of the document and places the cursor there. I need: (1) the scroll bar to be visable when the form opens, and (2) I want to placde the blinkinc cursor in front of the very first character in the text box. Thanks in advance, Jason Sweeney --- Message posted from http://www.ExcelForum.com/ . For (1): in the UserForm properties box (or in your VBA code) be sure to set ScrollBars=2 (ScrollBars = fmScrollBarsVertical) For (2): Private Sub UserForm_Activate() Me.TextBox1.SetFocus Me.TextBox1.CurLine = 1 End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm trying to fit lots of text in a cell | Excel Discussion (Misc queries) | |||
How to print cells with lots of text? | Excel Discussion (Misc queries) | |||
Large amount of text in cells - Problem text.xls (0/1) | Excel Discussion (Misc queries) | |||
Large amount of text in cells - Problem text.xls (1/1) | Excel Discussion (Misc queries) | |||
Cells containing lots of text will not wrap? | Excel Discussion (Misc queries) |