Scroll bar starting at bottom of form

[Adamaths]

Hi,

I'm building a user form via VB script, and the final section of the script sets the scrollheight of the form depending on how many textboxes etc. have been added by the code.

However, whenever the form is shown the scroll bar starts at the very bottom. I have tried the line

UserForm.ScrollTop = 0

However this only seems to nudge it up about 6 points (on average the scrollheight of the form is about 2000 points).

Any help on what I need to do to start the viewable form at the top would be greatly appreciated.

Thanks in advance,

Adam

[Tom Ogilvy]

Is the control with the TabIndex zero at the top of the form?

--
Regards,
Tom Ogilvy


"Adamaths" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I'm building a user form via VB script, and the final section of the
> script sets the scrollheight of the form depending on how many
> textboxes etc. have been added by the code.
>
> However, whenever the form is shown the scroll bar starts at the very
> bottom. I have tried the line
>
> UserForm.ScrollTop = 0
>
> However this only seems to nudge it up about 6 points (on average the
> scrollheight of the form is about 2000 points).
>
> Any help on what I need to do to start the viewable form at the top
> would be greatly appreciated.
>
> Thanks in advance,
>
> Adam
>
>
> --
> Adamaths
> ------------------------------------------------------------------------
> Adamaths's Profile:
http://www.excelforum.com/member.php...o&userid=31580
> View this thread: http://www.excelforum.com/showthread...hreadid=517368
>

[Adamaths]

That's sorted it.

Many thanks!

Adam