lots of text in text box problem

[jasonsweeney]

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

 

[K Dales]

-----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

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