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

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

--
Regards,
Tom Ogilvy


"Adamaths" wrote in
message ...

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

That's sorted it.

Many thanks!

Adam


--
Adamaths
------------------------------------------------------------------------
Adamaths's Profile: http://www.excelforum.com/member.php...o&userid=31580
View this thread: http://www.excelforum.com/showthread...hreadid=517368