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

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