UserForms, Scroll bars and initial positioning of contents

[Chris Watts]

I have created a UserForm in Excel 2007 to enable larger volumes of text to
be displayed than is allowed by MsgBox. When the area defined by the
UserForm is full then scroll bars appear. So far so good.

But the box initially displays with the vertical scroll bar set at a
position that show the bottom part of the text. What paramater should I set
to make the initial display showi the Top of the text?

TIA
Chris

 

[Chris Watts]

I have created a UserForm in Excel 2007 to enable larger volumes of text to
be displayed than is allowed by MsgBox. When the area defined by the
UserForm is full then scroll bars appear. So far so good.

But the box initially displays with the vertical scroll bar set at a
position that show the bottom part of the text. What paramater should I
set to make the initial display showi the Top of the text?

TIA
Chris

Found an/the answer. I added the line:

BigBox.TextArea.SelStart = 1

cheers
Chris