Scrollbar settings in a UserForm
 

Hi,

I have a userform with a vertical scrollbar which works fine, but the
scrollbar is slid at the bottom when it shows up for the first time.
The users woud have to slide it up to get at the beginning of the form.
I tried several settings in VBE under project properties for the form,
to have the vertical scrollbar at the top when the form is displayed
but without success.

Can anyone suggest any solutions ?

Thanks.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Scrollbar settings in a UserForm
 

Look at your tab order. The control with tab order zero should be at the
top of the form.

--
Regards,
Tom Ogilvy

mohsinb wrote in message
...

Hi,

I have a userform with a vertical scrollbar which works fine, but the
scrollbar is slid at the bottom when it shows up for the first time.
The users woud have to slide it up to get at the beginning of the form.
I tried several settings in VBE under project properties for the form,
to have the vertical scrollbar at the top when the form is displayed
but without success.

Can anyone suggest any solutions ?

Thanks.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Scrollbar settings in a UserForm
 

Hello Tom,

The tab order for the controls was correct - 0 thru 9 - top to bottom.
I had to change Tabstop to false(was true) for taborder 9. The rest of
them were false. Now it works great.

Thanks for your help in putting me on the right track.

Mohsinb.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/