VBA - How to make the text box initially show the first part of the text?

[Frank Krogh]

I have written som help text in a text box control in a userform. The text
box has a vertical scrollbar to show all the text.

First I position the cursor in the beginning of the text and then set the
Locked property to false.

Then I run the userform with the myUserform.show, but it only shows the last
part of the text I have entered in the text box.

How do I make the text box show the beginning of the text?

How do I print the text in a text box when it covers more than what is
visible in the text box area?


Thanks for suggestions.


Frank Krogh

 

[Rob van Gelder]

For the first question:

Private Sub UserForm_Initialize()
TextBox1.SelStart = 0
End Sub

I can't answer the second question - sorry.

 

[Tom Ogilvy]

grab the text from the textbox, paste it on a sheet, print the appropriate
area of the sheet, clear the cell.