listbox and vertical scrollbar

[mtm4300 via OfficeKB.com]

I have a userform with a listbox. The listbox has a vertical scrollbar.
However, each time the userform is loaded, the vertical scrollbar is at the
bottom of the list. How can I get the scroll, when loaded, at the top of my
list? Thanks in advance.

--
Message posted via http://www.officekb.com

[Dick Kusleika]

mtm

Me.ListBox1.TopIndex = 0

after you've populated it.

--
**** Kusleika
MS MVP - Excel
www.dailydoseofexcel.com

mtm4300 via OfficeKB.com wrote:
> I have a userform with a listbox. The listbox has a vertical
> scrollbar. However, each time the userform is loaded, the vertical
> scrollbar is at the bottom of the list. How can I get the scroll,
> when loaded, at the top of my list? Thanks in advance.